export to csv keeps cell in scientific notation

[rickmeister]

dear,

I have skimmed through the web but I cannot find an answer to my question... I am desperately in search how to keep numbers and not in scientific format in csv.

even though I have formatted my cell as text and inserted autofit, i do get the correct value (1212121212121212000000000000000000000) populated in my excel BUT in the formula bar it keeps showing the scientific format! when exporting this to csv, the scientific value is copied and not the long correct number string... can someone please help out?

Thanks a million!

[jindon]

Strange.
Are you opening csv file from Excel?
Open it via text editor like Note Pad.

[rickmeister]

Please Login or Register  to view this content.

[rickmeister]

this i smy code, i save the output as csv. When opening the saved output afterwards I get the scientific notation in the file

[jindon]

Then have you tried to open a newly created csv file from Note Pad?

[rickmeister]

via notepad would not help me out in my case since I need this csv to be loaded in external tool.

opening the csv via notepad still gives me 23456789012345E+18

[jindon]

CSV file is just a comma delimited TEXT file, so external tool will see how you open via text editor.
If origal excel file is showing like 1212121212121212000000000000000000000 in the cell, it should create the csv file like such.

The attached is a csv created from Excel.
Just open it via note pad. Right click on the Icon - Open with - select Note Pad.