View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AS400_EXCEL_John_B AS400_EXCEL_John_B is offline
external usenet poster
 
Posts: 1
Default How do I open a csv file and not have leading zeros eliminated

I have a File that I down Load from another system (AS400) which I converted
to CSV Format. Some of the Alphanumeric fields (cells) have legimitate
values that start with 0 (zeros).
When I open the file in EXCEL it strips the leading zeros from those fields.
How do I prevent that.?

I tried using " as a delimiter but it did not work.