Turnoff Autoformat in Excel

  • Thread starter Thread starter Iris
  • Start date Start date
I

Iris

Is there any other alternative? The solution provided of
formatting "the relevant cells
as text BEFORE entering the data" wouldn't work since
data has already been entered previously in a csv file.

I'm opening a csv file and it contains this number
322e275. Excel automatically converts 322e275 to
scientific. Is there a way to automatically turn off
autoformatting without highlighting a range of cells to
format and using an ' before the number.


Please help.

Thanks.
 
One way would be to change the file extension from .csv to .txt

When you try to open the file, Excel will launch the Text Import Wizard.
In step 3, select the column and choose Text for the Column data format.
 
Back
Top