Thread: How do I retain leading zeros in a column of numbers when file op
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default How do I retain leading zeros in a column of numbers when file op
Format the cells as text or else as a custom format, say 000000000

Dave
--
Brevity is the soul of wit.


"vontzy" wrote:

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?
Reply With QuoteReply With Quote