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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Back
Top