15 digit limitation question

C

curtev

I've read BethP's question and I have the same problem with zeroes after the
15th digit . But, I want to do calculations on 16 and 17 digit numbers.
What can I do to keep my numbers from turning into 000s. Thanks, curtev
 
D

Dave Peterson

You could keep the values as text, then extract what you want from the string
using =mid() or =left() or =right().
 
Top