Calculating massive numbers

[Pauljj]

I have just realised that excel only calculates with precision numbers up to 999 trillion, if I want to add figures together which contain up to 17 digits (99 quadrillion) is there any way this can be done without the last 2 digits changing to zero ?

Cheers

Paul

 

[oliver_penney]

I have just realised that excel only calculates with precision numbers up to 999 trillion, if I want to add figures together which contain up to 17 digits (99 quadrillion) is there any way this can be done without the last 2 digits changing to zero ?

Cheers

Paul

hmm, looks like a floating point limitation in Excel

how about splitting up the numbers in third

eg. 123456789012345678901234567 into 1234567890 | 1234567890 | 1234567000

then adding up the columns?

 

[pgc01]

Hi Paul

You can add numbers with 17 digits using decimals in vba.

I'm curious, why would you need a number with 17 significant digits in a real life application?

 

[mikerickson]

This link might help you, but Excel is not the platform for numbers that large. They can be made to work but slowly, very slowly.
http://www.ozgrid.com/forum/showthread.php?t=78323