Working with Credit Card Numbers

Credit Card numbers are 16-digit numbers and if you ever enter a 15 digit number into a cell, you may discovered that Excel changes the last digit to a zero.

So why would Excel change this number? It comes down to how Excel was coded. Excel can handle only 15 digits of numerical accuracy.

So what do you do if you need to enter a 16 digit number manually? Well first ask yourself if Excel is secure enough to store valuable credit card information. If you still want to proceed, you have 3 easy ways of entering in the information...

  1. Precede the credit card number with an apostrophe. Excel then interprets the data as a text string rather than as a number.
  2. Pre-format the cell or range by using the Text number format. Select the range, choose Home > Number and then select Text from the Number Format drop-down control.
  3. Enter the card number with dashes or spaces. Embedding a non-numeric character such as a dash forces Excel to interpret the entry as text.


1 comment:

  1. Technical omega replica problem Athletics bike race, rolex replica have a dialogue with people. For a copy of that trapped watches, fake rolex In particular, it is designed to pay homage for your tag heuer replica uk is that you have a great love of rolex replica watches, already knowing the hublot replica uk beloved by adult males to manage. In the case of rolex replica sale entirely optimal, to show masculinity. Of course, in many cases, the reason is the explosion was connected to a child's wish, or as an offer he has reached his limit, so he has, in doing this you will react. You can rolex replica uk this particular mobile installation knurled bezel twist temptation and procedures through chronograph stainless steel bracelet. Of course, it is possible rolex replica sale are expensive, but more than watches.