View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eyal Shwartzman
 
Posts: n/a
Default Problem opening csv files with hexadecimal values

Hello,

I'm using excel 2003 and i'm having problem with csv file that contains
values such as 123e4 since excel interpets it as 123*10^4. Is there any way
that I can write this number so excel will leave it as a string ?

I'm aware of the article
http://www.kbalertz.com/Q66033/Hexad....Imported.aspx
but the solution propose there to use the wizard is clumsy. I want to double
click on csv file and get the string.

Thanks, Eyal