MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Leading zeros in .csv's


Posted by Kirk Lehman on October 30, 2001 10:26 AM

I have to save out Excel worksheets as .csv's. How do I not lose leading zeros in the process? Thanks.


Posted by Mark W. on October 30, 2001 12:59 PM

Use a custom number format with a sufficient number
of zeroes. For example, if cell A1 contains the
value 123 and you want it saved as 000123 then
format column A as 000000 before you save the
worksheet as CSV.