Scientific Values to Regular values

[vbjohn]

Excel 2007..

How can I change a value in vba columns that show Scientific Values?

For example:
3.00+06 -> into its value of 3001350

thanks.

[Leith Ross]

Hello vbjohn,

Change the cell NumberFormat and set the number of decimals you want to show. You may also want to set the column width to Autofit to display all the digits.

[vbjohn]

GREAT! Thanks.