Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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. –  Ellesa Apr 3 '13 at 19:41

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.