View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Craig Craig is offline
external usenet poster
 
Posts: 7
Default Save as CSV and Retain Leading zero

I would like to Save As .csv and retain a leading zero for uploading into a
Yahoo shopper.

When I format the cell using Custom 000000 and save the file as .csv and
open it again the leading zero is missing.

Sample number to save as .csv
012345
023456
034567

--
Thanks!

Craig