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.
Microsoft (http://support.microsoft.com/kb/269370) explained this question.
To display credit card numbers correctly, you can:
With these 2 methods, you can also add hyphen