Properly Saving a .CSV File With an 11 Digit Numeric Field

[Sheldon Potolsky]

My VBA code saves a spreadsheet as a .csv (... FileFormat:=xlCSV).
The problem? The one numeric field, an eleven digit number, converts
to exponential form, which I don't want.
Any way to do what I am trying to accomplish?

Thanks, Sheldon

 

[Mike S]

My VBA code saves a spreadsheet as a .csv (... FileFormat:=xlCSV).
The problem? The one numeric field, an eleven digit number, converts
to exponential form, which I don't want.
Any way to do what I am trying to accomplish?
Thanks, Sheldon

I don't know if this will help or not, using Excel 2000 when I format
the cells in a column containing numbers with 11 decimal points as text
and save the sheet as csv, the numbers are saved with all of the decimal
points, I can see that by opening the csv file with a text editor. But
when I open the csv file in Excel, only 9 of the decimal places are
displayed. I couldn't find a setting to restore displaying all 11 of
them anywhere, although one probably exists.

http://www.eggheadcafe.com/software/aspnet/33796987/preserving-trailing-zeros-from-csv-file.aspx