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.
Bookmarks