15 precision Points (2k and 2k3)

[Jezza]

I have been playing around with this for a little while now and was just seeing if there was a work around. Let's look at these sums:

11x11=121
111x111=12321
1111x1111=1234321

...

111,111,111 x 111,111,111= 12345678987654321

If we do this in Excel the sum totals 12345678987654300 due to the 15 precision points being that this number is 17 digits long. I found some very clumsy add-ins for this calculation on the web which used the method of converting the number to a text string. Any of you got a good idea for code that would do this? For some reason my little head states that I could do a binary conversion but I think I am going nutty <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

[HansV]

Since Excel internally uses 15 significant digits, you must use some trick such as storing numbers as text if you want to work with extended precision numbers. You could write your own code for it, and it could be an educative excercise, but it would also be rather tedious. Add-ins such as xlPrecision (free version available) have already done the dirty work for you.

[Jezza]

Thanks Hans

Nice add-in, the other one I had, although clever just felt clumsy