I want to keep leading zeros in my excel spreat sheet, How?

[Mark Engbretsen]

I need to keep the leading zeros in my CSV files. How can I do this?

 

[Gary''s Student]

One way is to put an apostrophe (single quote) in front of the value

 

[CLR]

Pre-format the cells/column as TEXT

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

If you can see the leading 0's in excel, then after you create your CSV file,
don't import it back into excel to verify it.

Open that CSV file in Notepad--or your favorite text editor.

(Reopening in excel will lose those leading 0's--but they should be there in the
CSV file.)