Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheet dropping leading zeroes when exporting from SQL Serve. | Excel Worksheet Functions | |||
No decimals and leading zeroes | Excel Discussion (Misc queries) | |||
CSV leading zeroes | Excel Discussion (Misc queries) | |||
How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel | |||
single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions |