View Single Post
  #4   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 fall off in csv format.

The leading zeros are dropped when the .csv file is opened, not when it is
created. You can verify this by openning the .csv with NotePad.

To preserve the leading zeros, don't open the .csv by double-click. Just
open Excel and:

Data Import External Data... Import Data and select the .csv from the
dialog.

The Import Wizard will allow you to specfy Text rather than General and thus
save the leading zeros.
--
Gary''s Student - gsnu200764


"susanmarie" wrote:

leading zeros fall off in csv format. I need to know if this is normal or if
I need to make a change to formatting or some other option .