hi
in excel help, type the word spectications. click on calculation specs
15 digits is the max that excel will display. after that you start getting
the E thing.
excel knows what the number is but wil not display.

Regards
FSt1

"art" wrote:

Hello:

I have a number that I need to multiply by an 8 digit number. This comes out
to be a 16 digit result. However when I use Msgbox and use left(Number, 4)
the number shows as E.G. 8.35... how can I make that the result should show
as a full number not as "8.533424E+16"?

Please help.

Thanks