LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart problem: values in column A don't show as labels on x-axis digicat Excel Discussion (Misc queries) 1 January 9th 06 07:08 PM
Problem opening excel files from email DXC001 Excel Discussion (Misc queries) 1 October 3rd 05 07:56 PM
Problem With Opening Embedded Object After Turning On "Track Chang John A Excel Discussion (Misc queries) 0 August 3rd 05 05:02 PM
Problem opening an XML file in Excel - getting "ns1:macrosPresent" rprondeau Excel Discussion (Misc queries) 0 December 15th 04 03:39 PM
Slow opening files - possible cause and solutoin Bob Flanagan Excel Discussion (Misc queries) 0 November 29th 04 10:04 PM


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"