View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DavidC DavidC is offline
external usenet poster
 
Posts: 17
Default Excel converts string in CSV file as number

A file named test.csv has one line in it:

16E035

This is an accounting code used at our university. If I open that file,
Excel shows 1.6*10^36 in cell A1. If I specify that the value is a string:

"16E035"

Excel still converts it to 1.6*10^36. How should this value be entered in
the file so Excel leaves it as a character string?

Thanks for your help.