View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Young Andrew Young is offline
external usenet poster
 
Posts: 1
Default Opening CSV Files

Does anyone know how I can open a CSV file in Excel and
preserve any leading zeros. I thought that if the values
in the CSV file are wrapped in quotes Excel would treat
them as Strings but it doesn't. Is the only way to do this
is to use OpenText and set the columns to Text?

Thanks,
Andrew