I'm creating a form where you can enter a credit card number. I set a
custom number for the cell and described it as ####-####-####-####.
You can enter a 16 digit number just fine, but when you tab away from
the cell and the custom number takes place, it changes the last digit
to a "0". Has anyone else encountered this? How do I fix it?


--
CSBUG
------------------------------------------------------------------------
CSBUG's Profile: http://www.excelforum.com/member.php...o&userid=28846
View this thread: http://www.excelforum.com/showthread...hreadid=485951