Hi,

I have a set of data that is downloaded as a CSV file like so:

4552
3.00E+03
3.00E+22
3F45
3.00E+99
4
37


Excel automatically thinks that 3E03, 3E22 and 3E99 are numbers and makes them look like above..

I need a formula that will automatically reconvert to text strings..and leave the actual numbers like 4552, 4, 37 as is...

I tried this formula: =SUBSTITUTE(TEXT(G1,"0E+00"),"+","") but that is converting all numbers to an 0E+00 format..

Thanks.