Credit card numbers are never used to do maths with, they're just unique identifiers.
Import them as text, then you won't get rounding errors.
How are you exporting/importing this stuff into Excel?

Hi p45cal,

Thank you for your reply.

I am using a tool called dataloader.io (used for Salesforce data). I'm not actually having a problem with the exporting/importing. I can export and import it back in and the data is fine, so I know the data is there. But when I try to view in Excel I cannot see the 16th digit. I tried converting the field to text, but it shows a 0. Like I said, when I import it the last digit is correct (not 0) so I would think there should be a way to format it in Excel so I can view the last digit.


Thanks,
Burt