A
Alex
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?
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?