Excel's number precision is maximum 15 digits. So you wont be able to retain
the 16 digit. It is not unique to your format and is a general limitation. I
suggest you define 4 cells in your form to input the card number.
Alternatively, you can use a text box.

"CSBUG" wrote:


If this form is for other people to use. I want them to just type in
the 16 digits and have it format itself. Without having to explain to
150 people that they need to start every entry with an apostrophe.
Should I put the apostrophe in the custom number script?



Gary''s Student Wrote:
Precede you entry with a single apostrophe.
_____________________________________
Gary's Student


"CSBUG" wrote:


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




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