last digit of a 16 digit number automatically changes to zero.

[Guest]

When I type a 16 digit credit card number, Excel changes the last digit to
zero regardless of what number is actually typed in.

 

[Rick B]

This is not an EXCEL newsgroup. This is an ACCESS newsgroup.

 

[Guest]

Go into the table in 'design' view. Click on the credit card field number.
'Field Size' in the bottom half of the screen is probably 'long integer'?
You probably want it to be at least 'Single'.

 

[John Vinson]

Go into the table in 'design' view. Click on the credit card field number.
'Field Size' in the bottom half of the screen is probably 'long integer'?
You probably want it to be at least 'Single'.

Single is limited to about 7 digits, Double to 14.

A Credit Card Number isn't a *number* in the sense that you'll never
want to do calculations with it. It should be stored in a Text field,
not any kind of number field.

The OP was asking about Excel, not Access, in any case.

John W. Vinson[MVP]