15 digit limitation question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You could keep the values as text, then extract what you want from the string
using =mid() or =left() or =right().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does Excel replace any digits beyond 15 with zeros? 2
Excel Changes My Last Digit to Zero 1
17 digit number 3
Zero appears at the end of a string of 16 digits. Two zeros after 4
maximum number size/significant digits 4
16 digits 10
XL 2k - all digits in cell turn to 0 after 16th digit 1
Number of significant digits allowed in a cell is 15. 2

Back
Top