Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have in table column, his type is decimal and in him is stored numbers like this

2.3
2.0
3.3
4.2

I want export this table in excel, I export table as csv file.

But when open csv file in excel, data like this 4.2 displayed as 04.02.2013

I need that 4.2 displayed as 4.2 in excel, how to make this?

share|improve this question

migrated from dba.stackexchange.com Apr 3 '13 at 19:13

This question came from our site for database professionals who wish to improve their database skills and learn from others in the community.

    
Best practice is to NEVER open CSV files in Excel. You can either import data in the file, or force Excel to go through the Text Import wizard by changing the file extension to TXT. – Kaze Apr 3 '13 at 19:41

Don't double-click on the .csv file but open Excel and Data > Get External Data - From Text. Choose the .csv file and click Import. Select Delimited and click Next. Select Comma etc as necessary and click Next. At this point ensure that Column data format is not Date.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .