You may have noticed that when entering more than 15 digits, Excel changes all digits past 15 to zeros. This prevents longer numbers like credit card numbers from displaying correctly, but there’s an easy fix: formatting the cell.

Right click in the cell you want to enter the credit card number and select Format Cells. Under category, select Text and click okay. Now, anything entered in that cell will remain exactly as typed. You may get an error notification that a number is being stored as text, but that’s okay – if it’s a credit card number, you’re not going to be performing mathematical equations on it.

Unfortunately, if you’re trying to find out what that 16th digit was, this will not help that as it is not retroactive.

I also show you how you can custom format the expiration date to display as MM YY.

Don’t forget to subscribe to my channel for more tutorials!

Thanks for tuning in!

Advertisements