Product: ImportOmatic

Description: This solution describes how to correct credit card numbers that come in as scientific notation.

Environment: All

Version: All

Answer:

Save the file in question with a file type of .csv

Select the entire column containing the credit card number or skewed numeric value. Right click and select Format Cells, select the category of Text then select OK to save changes to the  the cell format to Text instead of Number.