how to keep leading zeroes when saving in xls in csv format

J

Joe

I have a column in the excel sheet that is of the in this format-> 00001234,
But when I am saving it in the CSV format it does not show the leading zeroes
for some reason. Can anyone please tell me if there is a way to keep those
leading zeroes.
Thank you
 
J

JR

I just tried this, using a decimal point (.00001234), and it worked. You
will need to select "Yes" when it asks about formatting, when saving as a csv.
 
D

Dave Peterson

If you open that .csv file in notepad, do you see the leading 0's?

Excel will drop those leading 0's if you reopen the file in excel. That might
not be a problem--depending on what you're doing with that .csv file.
 
Top