Problem opening csv files with hexadecimal values

E

Eyal Shwartzman

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/Hexadecimal.Values.Changed.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
 
P

Pete

Change the file extension from .csv to .txt then in Excel use File |
Open (file type = All files) and select the .txt file. This will
automatically take you into the Data Inport Wizard, and on the 3rd
panel of this you can specify the data types that you want each column
of data to be treated as, so you can set Text for this column.

Hope this helps.

Pete
 
P

Pete

You can record a macro while you do the import once, then apply this to
future imports.

Pete
 
E

Eyal Shwartzman

Thanks for the answer, but I was looking for something more simple than a
macro, maybe a certain type of way to print to the csv file.
 
P

Pete

You can set up your macro when you record it so that it can be run in
future with a combination key press (eg CTRL-SHIFT-G). Next time you
want to import data you will just repeat this key combination and away
it goes ...

Pete
 
Top