Excel long number (IEEE 754) workaround

[wit1111]

Hi all,

I think this issue has been dealt with extensively but I am unable to find the relevant thread.

I have a 20 digit number that excel is converting to zero's due to its specification. I am able to display the number by converting into text. However, I need to create logic which allows me to utilize the number in a formula and return the correct 20 digit number.

For example, in cell A1:

#####-#####-#####-#####

in cell A2:

=A1+1

I need A2 to reflect the correct value. As the input is text it is merely just showing the formula in A2.

Any suggestions would be very well received.

Many thanks

 

[thisoldman]

There is an add-in, xlPrecision, that allows arbitrary precision for numeric calculations. The free version is nagware and is limited to 3,000 digits. My use has been extremely limited, two one-time use workbooks.

http://precisioncalc.com/what_is_xlprecision.html