The value 9.00418E+11 is scientific notation and means 9.00418 x 10 to
the 11th power: 900418000000.00

To make it display properly, change the number format to something more
appropriate:
FormatCellsNumber
Change category to Number

Adjust the column width as necessary.

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=471119