CSV file and number formatting

[fsm]

Hello,
I am trying to create a csv file from an excel worksheet. The proble
is when I open the file in excel, I get scientific notation. I als
have numbers that are supposed to be text. some of these numbers star
with zero, so most of the time it is lost when converting to csv with n
formatting.

How can I do this

 

[Earl Kiosterud]

fsm,

After saving the sheet as csv, open it with NotePad. NotePad won't change
formatting of the stuff as does Excel -- it just shows you the actual
characters in the file. For more about text files in Excel, see
www.smokeylake.com/excel/textfiles.htm.