I created a custom format for credit card numbers using XXXX-XXXX-XXXX-XXXX.
But when I key a number into the formatted cell, the last (rightmost) digit converts to zero.
So when I enter, for example, 5511246190465589 the cell displays 5511-2461-9046-5580.
Any ideas?
Bookmarks