Microsoft Office Tutorials and References
In Depth Information
Entering Credit Card Numbers
Entering Credit Card Numbers
If you’ve ever tried to enter a 16-digit credit card number into a cell, you might have discovered
that Excel always changes the last digit to a zero. Why? The reason is that Excel can handle only
15 digits of numerical accuracy.
If you need to store credit card numbers in a worksheet, you have two options:
h Precede the credit card number with an apostrophe. Excel then interprets the data as a
text string rather than as a number.
h Preformat the cell or range by using the Text number format. Select the range, choose
Number, and then select Text from the Number Format drop-down control.
This tip, of course, also applies to other long numbers (such as part numbers) that aren’t used in
numeric calculations.
Search JabSto ::

Custom Search