Macro to convert scientific notation to correct text format

[exceleratevba]

Hi,

I have the following excel file that is downloaded from the site below.

The file has codes in column A that are being converted to scientific notation due to the code format. The codes should be 0E1, 1E0, 2E0 and so forth but they end up looking like format below.

0.00E+00
0.00E+00
0.00E+00
0.00E+00
0.00E+00
0.00E+00
0.00E+00
0.00E+00
0.00E+00
0.00E+00
1.00E+00
1.00E+01
1.00E+02
1.00E+03
1.00E+04
1.00E+05
1.00E+06
1.00E+07
1.00E+08
1.00E+09
2.00E+00
2.00E+01
2.00E+02
2.00E+03
2.00E+04
2.00E+05
2.00E+06
2.00E+07
2.00E+08
2.00E+09

I'm currently manually correcting these, is there a formula that can check the cell/data and convert it to the correct format in column I?

[shg]

Instead of opening the file,

Data > Get External Data > From Text

Select the file, Tick delimited, select comma as the delimiter, and import col A as text.

[exceleratevba]

Awesome, this did the job.

Thanks!

[shg]

You're welcome.