Entering 16 digit numbers in cell

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

Guest

When I type in the 16 digits, Excel changes the last digit to 0 so I don't
have a correct number listed.
How can I get it to accept all 16 digits correctly?
Thanks
 
Excel, like nearly all software, supports only 15 digits of precision.
Anything beyond that is no man's land. If you need to store a longer number
but not perform calculations with it (e.g., a credit card number or phone
number), precede the number with an apostrophe. The apostrophe will not be
visible in the cell but will be visible in the formula bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Hi

either pre-format the cells as Text, or enter a single quote before the
number, which will force it to be text.
'0123456789012345
 

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

16 digit numbering 8
Number Problem 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
How do I stop Excel from changing last digit in a number entry? 1
Custom Format on 16 Digit Number 5
Date and Number cell formats 4
Excel 3
16 digit number entry changes last digit to 0 1

Back
Top