16 digit numbers

G

Guest

I am trying to enter a 16 digit credit card number into an excel spreadsheet.
For some reason however excel is truncating the last numerial and replacing
it with a '0'. It displays 15 digit numbers fine. Why is this and how do i
fix it? (ive tried cell formatting but to no avail)
 
N

Niek Otten

Excel's precision for numbers is 15 significant digits.
You can enter your credit card number as text by either formatting the cell
as text before entering the number or by preceding the number with a ',
which will not show.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
G

Guest

If u said this only for typing credit card purpose, not to cummulated I
suggest you change your format cells into "TEXT".
Good Luck..
 

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
16 digit number entry changes last digit to 0 1
Entering a 16 digit number 1
Excel Changes My Last Digit to Zero 1
Typing a credit card number in a cell 3
"Bug" in number format for long number entries? 7
last digit in string gets changed to 0 (16 characters long) 3
rounding problem need accuracy when using V Lookup 2

Top