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.
