Number fields

[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

 

[Peo Sjoblom]

Use text format or precede the entry with an apostrophe

 

[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.