View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carrol Carrol is offline
external usenet poster
 
Posts: 4
Default Remove leading zero in xls when converting to csv forfield contain

2 Character columen contains both character and numerics, example 4B and 02.
The 02 is converted to 2 in the CSV file regardless of whether the cell is
formatted as general, text, or custom. I also used a value of '02 to identify
it as text value and it still converted it. How do I prevent it from removing
the leading zero? Thanks