VBA macro for "power" with 15> digits accuracy

[aolo]

Hi everybody!
I need a marco to make powers whose results are accurate and longer than 15 digits.

For example:
23^32

Accurate result: 37.608.910.510.519.071.039.902.074.217.516.707.306.379.521
Excel result using "=power" formula 3,76089E+43 <--it is not accurate. For my needs I need the complete and exact number.

I know that Excel has a 15 digits accuracy, but I hope to bypass the problem using VBA.
Can someone suggest me a macro who can help me?
Thank you!

[MarvinP]

Hi aolo,

I find http://precisioncalc.com/What_is_xlPrecision.html searching the net. See if this works for you.

[mikerickson]

I would seriously consider using a different program than Excel. There are work-arounds, like the link that Marvin posted, but Excel is built for 15 digit accuracy. Your life might be easier if you used a program designed for number crunching instead.

[aolo]

Thank you MarvinP.
It could have been perfect, but I can't install this excellent add-in cause I don't have administrator's credentials.
By now I think a macro can be the only way.
Thanks again!

[aolo]

Thank you mikerickson. Unfortunately I can only use Excel with no other add-in. Just VBA...