Importing Credit Card Numbers and Excel

[Guest_imported]

Hello, I am importing a tab delimited text file into Excel
that contains credit card numbers. For some reason (which
is why I am here), Excel always changes the 16th (which is the last) number to zero. Anything less than 16 numbers works great.

Tech Support from another company told me to
format that cell as 'text' but that doesn't work. I tried
formatting to 'number' but to no avail.

In summation, I want to know how to import a 16 digit
credit card number into Excel so that all numbers are
exactly the same as the ones in the text file.

Thanks!

 

[schat]

I don't know what difference this would make, but you could try importing the file into Excel using the fixed width option rather than delimited, using 4 columns for the 16 characters, then concatenate each row afterwards.

 

[AndreasG]

hello JBTEX

You must import the numbers as text not as general format
Excel maintains only 15 significant digits for numbers thus
your problem.


hth Andreas
using xl2000 on win2k