all 16 digit numbers end up with 0

G

Guest

Every time I put a 16 digit number in excel the last number changes to 0 and
I cannot figure out a way to keep the original number. I have tried
formatting the cells to no avail.
 
C

Chip Pearson

Excel supports only 15 significant digits. To enter a longer
number, such as a credit card number, precede the number with an
apostrophe. Any arithmetic you do with this number is still
limited to 15 digits.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...
 

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

Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
i enter a 16 digit number the last digit converts to a 0...help 4
Numbers corrupted in Text fields 1
16 digit number entry changes last digit to 0 1
Custom formatting in Excel 2007 1
16 digit numbers 2
Custom Format on 16 Digit Number 5
numbers cannot appear until 15 digit if ended with '0' 1

Top