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

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

In four characters, how would you want the number to appear?


--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=28839

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.

"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