Excel+limit+of+15+digit+numbers+in+a+single+cell

In trying to put a credit card number into an Excel cell (16 digits), Excel added a 0 after the number. Found via Google: Excel will not allow input of more than 15 digits into a cell - "Excel has a limitation of 15 significant digits. ... for instance if I put in 1111111111111111 it shows up in the cell like this 1111-1111-1111-1110"

One solution is to split the number up into different cells if you simply want to display it.

Also, if you don't need the number to be formatted as a number, simply change the cell format to text - that way you can display longer numbers.