Re: text string: "91E10" in csv file auto converts to: "9.10E+11"

Tech-Archive recommends: Speed Up your PC by fixing your registry

Don't open the CSV file that way (nor by using File / Open from within
Excel).

From within Excel, use Data/ Import External Data/ Import Data.
In the text import wizard, specify the relevant column as Text if you don't
want Excel to reformat them.

Another option is to rename the file from .CSV to .TXT, and that will enable
the text import wizard when you try to open the file with Excel.
--
David Biddulph

"Alex@xxxxxxxxxxxxxx" <Alex@xxxxxxxxxxxxxx@discussions.microsoft.com> wrote
in message news:768FB722-E037-4AFB-875E-9EBA9F06851B@xxxxxxxxxxxxxxxx
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?


.

Relevant Pages

  • RE: Text import/ Text to Column
    ... which is why does the Text Import Wizard not work with over 65K records? ... what does not work is to run Text to Columns - because the data when Excel ... MY QUESTION IS -- is there a fix for the 'Text Import' to allow MORE THAN ... double click on the .csv file and it willopen in excel. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Incorrect formatting opening .csv file in Excel
    ... This will kick off the same text import wizard. ... > directly in Excel. ... > its formatting. ... values" from your csv file. ...
    (microsoft.public.excel.misc)
  • Re: Text import/ Text to Column
    ... Then in a new file created in Xl2007, I opened the text file, the wizard ... less than 65K records when Excel 2007 is supposed to work with over ... MY QUESTION IS -- is there a fix for the 'Text Import' to allow ... double click on the .csv file and it willopen in excel. ...
    (microsoft.public.excel.worksheet.functions)
  • CSV numeric strings
    ... I'm having a little "fun" creating a CSV file from an ASP page for use with ... Excel tries to be smart about things. ... I know the trick when manually entering a value in a cell that is numeric ... but you want treated as a string. ...
    (microsoft.public.excel)
  • Re: CSV import, excel corrupts data
    ... I guess if you want to use excel, you'll have to play by its rules. ... If opening .csv files directly doesn't work for you, ... Doing the macro trick corrupts the data as described when the file is a ... empty worksheet, use the data import wizard to select the csv file, ...
    (microsoft.public.excel)