LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Disable conversion from text to number from .csv file

I need to generate a .csv file that will not have columns automatically
converted to numbers when they are in fact text. For example, I have a CUSIP
"6471989E2" which is converted to 647198900 by Excel automatically. I have
tried surrounding field in double quotes but that has no effect. Single
quotes avoid the conversion, but the quotes appear in the spreadsheet, also
undesirable.

Note: I must have a 'double-click' solution. The file must open correctly on
a double-click without any user intervention or special importing.
For example, is there a non-printable escape character that can be added to
the field that would tell Excel that it must treat the field as text?

Thanks,
--
Steve Forest
 
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
Text file conversion to excel Michael M[_2_] Excel Discussion (Misc queries) 1 May 16th 08 08:28 PM
Text to Number conversion ALLYANA New Users to Excel 6 October 16th 06 03:33 PM
Conversion to Text file format error Rob Excel Discussion (Misc queries) 1 June 26th 06 10:33 AM
PREVENT conversion of text to number? celticvalley Excel Discussion (Misc queries) 2 August 17th 05 02:52 PM
Conversion of a Number into English Text Nasir Ali Excel Worksheet Functions 1 July 28th 05 08:50 AM


All times are GMT +1. The time now is 07:42 PM.

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

About Us

"It's about Microsoft Excel"