Microsoft Office Tutorials and References
In Depth Information
Importing credit card numbers
Importing credit card numbers
If you’re importing credit card numbers from a CSV text file, Excel will import the credit card numbers
as values — and erroneously change the last digit to zero. To avoid this, don’t use File➜Open to
import the text. Rather, use Data➜Connections➜Get External Data➜From Text. When you use this
command, Excel displays the TextImport Wizard. In Step 3 of the wizard, make sure that you specify
Text as the column data format for the credit card numbers. See Figure 61-1.
Figure 61-1: Using the TextImport Wizard to ensure that credit card numbers are imported as text.
Search JabSto ::

Custom Search