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 
or space
Please help me.
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.
Example:
To display credit card numbers correctly, you can:
With these 2 methods, you can also add hyphen 

