E+16 in number

[art]

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

 

[FSt1]

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

 

[Shane Devenshire]

Hi,

You're seeing the results in scientific notation, in your code you might
want to look at the FORMAT(X,"###,###,###,###,##0") function where X is the
number your calculation is returning. Also, it would be good to look up CInt
in the VBA Help system to understand a little about type conversions.

FYI - in the spreadsheet Excel shows and works with a maximun of 15 digit,
but your largest number can be ~1X10^304 (10 to the 304th power)

If this helps, please click the Yes button.