Accurate/Precise Large Number Calculation

[kpark91]

Hello, I am currently solving Project Euler problem 16 and I'm having troubles with one of the VBA features.

Whenever I want to calculate a large number (2 ^ 1000) to add up the digits, I can't! because VBA keeps on fixing the number to scientific notations ignoring all the digits after several digits!

Is there a way to get around this?

Thank you in advance,
kpark

 

[kpark91]

bump

 

[kpark91]

bump xD

 

[shg]

It's not the scientific notation that's a problem -- it's that your computer only calculates 15 digits of precision, far fewer than the 300-odd digits you need to represent 2^1000. The point of the problem is to figure another way.

 

[kpark91]

Oh. Danggggggg T.T Worst-case scenario lol.

Thanks shg as always