I've tried a custom format for entering credit card numbers (four groups
of four digits, separated by dashes: xxxx-xxxx-xxxx-xxxx.

I have tried to use ####-####-####-#### and 0000-0000-0000-0000 but
each of these causes the last digit to change to zero. So if I enter
5415779800902512 I get 5415-7798-0090-2510.

Anybody already solved this problem?


--
Schmacker
------------------------------------------------------------------------
Schmacker's Profile: http://www.excelforum.com/member.php...o&userid=28041
View this thread: http://www.excelforum.com/showthread...hreadid=475488