15 digit limitation question
 

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

15 digit limitation question
 

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



curtev wrote:

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

--

Dave Peterson

15 digit limitation question
 

If you must use more precision then download the Xnumbers addin from
http://digilander.libero.it/foxes/SoftwareDownload.htm
OR program in COBOL
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"curtev" wrote in message
...
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

15 digit limitation question
 

Great. Thanks Much ! I think this will work.

"Bernard Liengme" wrote:

If you must use more precision then download the Xnumbers addin from
http://digilander.libero.it/foxes/SoftwareDownload.htm
OR program in COBOL
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"curtev" wrote in message
...
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