Leading zeros won't convert to csv file in Excel ver 6 SP2
It does not matter if you had the leading zeros because the cell was formated
as text, or formatted as Custom 0000, or started with an apostrophe. After
saving as .csv the zeros should still be there.
Verify this by opening the .csv file with Notepad.
Its when you re-open the file with Excel that the leading zeros get dropped.
--
Gary's Student
"Pedro" wrote:
After formating the numbers for leading zeros and saving as a csv file, the
leading zeros drop off. This process used to work fine for me and just quit
doing it.
|