Hi all,
I'm currently creating a database that must hold 16 digit credit card numbers. The numbers should be formatted so that there is a space after every four numbers (eg. 1234 1234 1234 1234). When I copy and paste the card numbers into Access from Excel, I end up with "2.1528492378042E+15".
Is there anyway around this?
Thanks in advance.
PS: This is for a college project, I'm not actually storing real card numbers.