Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem opening csv files with hexadecimal values
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem opening csv files with hexadecimal values
You can record a macro while you do the import once, then apply this to
future imports. Pete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem opening csv files with hexadecimal values
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. "Pete" wrote: You can record a macro while you do the import once, then apply this to future imports. Pete |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem opening csv files with hexadecimal values
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
Problem opening excel files from email | Excel Discussion (Misc queries) | |||
Problem With Opening Embedded Object After Turning On "Track Chang | Excel Discussion (Misc queries) | |||
Problem opening an XML file in Excel - getting "ns1:macrosPresent" | Excel Discussion (Misc queries) | |||
Slow opening files - possible cause and solutoin | Excel Discussion (Misc queries) |