View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default How do I retain leading zeros in a column of numbers when file op

Rename your csv to .txt, use the wizard to open the txt file in Excel, and
format the column to text before you finish the import.
--
David Biddulph

"vontzy" wrote in message
...
I need to retain leading zeros in a column of numbers, such as 001001001.
The 00 must be retained when a csv file is opened.

How?