how to keep leading zeroes when saving in xls in csv format
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. "Joe" wrote: 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 |
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. Joe wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 01:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com