View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.