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.
That number is bigger than the biggest integer Excel can hold as a number.
Set the cell format to text before entering the number, or type an apostrophe at the start.
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:
To add hyphen
Instead of formatting as text, you can also begin the credit card number with apostrophe (link), so that it is interpreted as text.