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
|