CSV file doesn't save "xEy" style number as text formatted data

  • Thread starter Thread starter akarui.tomodachi
  • Start date Start date
A

akarui.tomodachi

I need a data sheet with alpha-numerical values like 2E5 in a CSV
(Comma Separated Values) file. But if I put any alpha-numerical value
with "E" in it, after format and saved as "Text", it doesn't save as
I entered. After opening the saved file I see the number is changed to
scientific formatted value 2.00E+05.

How can I make the CSV file save my xEy style entry permanently as
"Text" formatted data.

How to reproduce:
1) Open a new Excel file
2) Select a cell
3) Change the Cell's format to Text (Format->Number->Text)
4) Enter 2E9 in that cell and save as .CSV file
5) Close the file and reopen it
6) The format is changed to Scientific and previously entered data
appears as 2.00E+09

Thanks.
 
After you save the data as a .csv file, don't use excel to reopen your text
file.

Open that .csv file in a plain text editor--like NotePad.

If you need to reimport the data into excel, rename the file to *.txt and then
use file|open. You'll be able to specify that this field should be treated as
text.
 
Back
Top