While trying to fill in credit card numbers into Excel 2010, when I write 4645890379859736 last number becomes 0
Example:4645890379859736 is turned into 4645890379859730
Note: I can't use any
Please help me.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
Excel stores only 15 significant digits in a number, and changes digits after the fifteenth place to zeroes.
To work around this behavior, format the cell as text, then type the numbers. The cell can then display up to 1,024 characters.
Microsoft Support explained:
Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers. Excel therefore stores only 15 significant digits in a number, and changes digits after the fifteenth place to zeroes.
If you type the number 1111222233334444 in a cell that uses the ####-####-####-#### format, Excel displays 1111-2222-3333-4440 in the cell. The actual number that you are attempting to store is 1,111,222,233,334,444, which is over one quadrillion. But because this number is so large, Excel drops the last (least significant) digit, and puts a zero in its place.
To add hyphen
- or space
If you type the number in the cell that is formatted as text, all the characters remain as you type them, because Excel does not attempt to store the credit card id as a number, but leaves it as text.
Instead of formatting as text, you can also begin the credit card number with apostrophe (link), so that it is interpreted as text.