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

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
CSV leading zeroes 2
Preserving '00nnnn' in xls to csv file saving 1
leading zeroes in CSV files 4
Format cells in web query (leading zeroes) 5
Leading zeroes get dropped when converted to text 8
How can I retain leading zeroes when saving as a CSV file? 1
Leading Zero Dropped in Text Cell 3

Top