Thread: converting
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default converting

Don't reopen the .csv file in excel. That's what's losing the leading zeros.

Use Notepad to verify that your .csv file is correct.

csmith wrote:

I have placed leading zero in my excel doc and try to save as CSV file it
drops my leading zero even when I put the leading zero back into the CSV file
it will not save. Any suggestions?
--
csmith


--

Dave Peterson