Text fields are treated as numbers when opening CSV file

  • Thread starter Thread starter dsadsadasdsa
  • Start date Start date
D

dsadsadasdsa

I have cell in CSV file that has string 03073E105 in it (this is CUSIP).

When I open it in Excel it looks like 3.073E+108

I understand what happens and why but this is not what I want.

Is there a way to achieve every cell to be treated as text?
 
I'd rename the .csv file to .txt

Then when I did file|Open, I'd be prompted for each field type.

You could also try using Data|Import external data|Import data, too.
 
I have cell in CSV file that has string 03073E105 in it (this is CUSIP).

When I open it in Excel it looks like 3.073E+108

I understand what happens and why but this is not what I want.

Is there a way to achieve every cell to be treated as text?
Click to expand...

You can format the cell to number (it defaults to general) to just
show the number. If you want to display leading zeros make a custom
format of 000000... with 1 zero for each place.

select the cell(s) and got to format/cell and click on the number tab.
 
Back
Top