Converting cells with E+12 etc to number

[Miya]

Hi, in col A i have mnay cells which house large numbers and are reflected similar to the below. How can i convert them to proper numbers?


<table border="0" cellpadding="0" cellspacing="0" width="86"><col width="86"><tr height="19"> <td style="height: 14.4pt; width: 65pt;" align="right" height="19" width="86">5.00083E+12</td> </tr></table>

 

[mirabeau]

How about Format Cells --> Number ?

 

[Miya]

How about Format Cells --> Number ?

Fo future ref, is there VBA code that will look in Col b of each worksheet and convert to number?