custom number format

[Guest]

I created a custom format to accomodate a credit card number, after i enter the number the last digit is displayed as 0 no matter what number i have put in. EX: 1111-1111-1111-1113 displays as 1111-1111-1111-1110, HELP

 

[RagDyer]

You must *pre-format* the cells as Text, before entering your data,
OR
Enter an apostrophe (') as the first character in the cell.
The apostrophe will be visible in the formula bar, but *not* in the cell.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I created a custom format to accomodate a credit card number, after i enter
the number the last digit is displayed as 0 no matter what number i have put
in. EX: 1111-1111-1111-1113 displays as 1111-1111-1111-1110, HELP

 

[Debra Dalgleish]

Excel only stores 15 significant digits, as explained in the following
MSKB article:

XL: Last Digits Changed to Zeroes When You Type Long Numbers in Cells
http://support.microsoft.com/default.aspx?id=269370

You'll have to store the number as text, as Ragdyer described, and type
the hyphens yourself.