Leading Zeroes

C

Craig

I am trying to save an Excel spreadsheet as a .csv (comma
delimited) file. The problem is that whenever you open
the .csv file, you find that on some of the fields, the
leading zeroes are cut off. I need to know why this
happens and how to stop it. All the fields in the
original Excel file are set to text. Thanks for any help.

Craig
 
E

Earl Kiosterud

Craig,

If you're reopening the csv file in Excel, it is likely formatting those
fields as numeric, dropping the zeroes. Try opening it in Notepad. Notepad
shows you character for character what's in the file. If you really can't
get Excel to write the file as you need, try the Text Write Program (and
Excel workbook with a macro). www.tushar-mehta.com.
 
Top