I have a spreadsheet where I enter credit card numbers, 16 digits. One note, I have the field setup as a custom format, that displays in the custom format as ####-####-####-####. This way it automatically adds the 4 dashes.

For some reason, it always changes the last digit to zero. For example, I enter 1111222233334567, after I hit enter, it becomes 1111-2222-3333-4560.
WHY is it doing changing the 7 to a 0??



This error, of changing the last digit to zero, only occurs when I type my data into my custom format field.