Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text string: "91E10" in csv file auto converts to: "9.10E+11"
91E10, and similar, are Military PMOS codes (job codes). When the comma
delimited csv file is read in, Excel automatically converts any string containing "E" into what appears to be exponential notation. In the csv file the string is delimited as ,"91E10", between other data fields. The file is opened by clicking on the csv file without Excel running, after which Excel's file association type loads the csv file in, during which it converts all strings containing a capital "E". How do I disable this undocumented feature? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how to converts a number to text eg. "2" become "two" | New Users to Excel | |||
how to converts a number to text eg. "2" become "two" | New Users to Excel | |||
converts a number to text eg. "2" become "two" | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |