how to turn off automatic cell value format on excel

[mario99ukdw]

Hi, How to turn of automatic cell value format on excel? I have script for exporting table database into csv but if that file open on excel, some value are changed by excel for example : original value : 11.11 become 11 Nov I am using germany regional setting on windows

 

[pgc01]

Hi Mario
Welcome to the board

If you open the csv directly excel will interpret values.
In this case you should import that specific column as Text. How are you opening the csv, manually using the menu or using code?

 

[mario99ukdw]

Hi,

I am opening directly using open menu, how do i import that specific column as text or can i import all column as text defaultly?

 

[pgc01]

You just have to rename the file extension to txt, like filename.csv to filename.txt

If you open it in excel you'll get the text import wizard that works like the text to columns feature in excel.

In the first panel you choose delimited, in the second you set your delimiters (comma, in your case, or tab, I guess) and then in the third panel you can click on the column with the date and set it to Text in the option button above.

Please try.