Entering 16 digit numbers in cell

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
 
C

Chip Pearson

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)
 
R

Roger Govier

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

Number Problem 2
16 digit numbering 8
Date and Number cell formats 4
For John, et al. Re Combining Columns (previous post) 4
Sorting Problem 1
How do I stop Excel from changing last digit in a number entry? 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Numbers as Text 1

Top