Number fields

L

Larry

I have a number field for credit cards and it wont take
the 16th number, it automatically rounds it to a zero...
example 4888 6032 1234 5678 if input will show 4888 6032
1234 5670........ I have tried validation etc and it still
shows a 0.... Any suggestions.

Larry
 
T

Tom Ogilvy

.. . . Because Excel only stores numbers with 15 digits of precision. But
since you won't do math with a credit card number, you don't need to store
it as a number - text will suffice as suggested by Peo.
 
Top