Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text file conversion to excel | Excel Discussion (Misc queries) | |||
Text to Number conversion | New Users to Excel | |||
Conversion to Text file format error | Excel Discussion (Misc queries) | |||
PREVENT conversion of text to number? | Excel Discussion (Misc queries) | |||
Conversion of a Number into English Text | Excel Worksheet Functions |