Last Digit
 

Hello
I created a custom number to enter credit card numbers. e.g. #### #### ####
####. (sixteen digits a space every 4 digits)The problem is that the last
digit always comes out as 0 If I type 1234 1234 1234 1234 it reads 1234
1234 1234 1230 thanks

Last Digit
 

Excel truncates to 15 digits, even in custom format.

To preserve the 16th digit, format as Text or precede the entry with a
single quote (apostrophe)
--
Gary's Student
gsnu200701


"Wanna Learn" wrote:

Hello
I created a custom number to enter credit card numbers. e.g. #### #### ####
####. (sixteen digits a space every 4 digits)The problem is that the last
digit always comes out as 0 If I type 1234 1234 1234 1234 it reads 1234
1234 1234 1230 thanks

Last Digit
 

Thank you Gary.....

"Gary''s Student" wrote:

Excel truncates to 15 digits, even in custom format.

To preserve the 16th digit, format as Text or precede the entry with a
single quote (apostrophe)
--
Gary's Student
gsnu200701


"Wanna Learn" wrote:

Hello
I created a custom number to enter credit card numbers. e.g. #### #### ####
####. (sixteen digits a space every 4 digits)The problem is that the last
digit always comes out as 0 If I type 1234 1234 1234 1234 it reads 1234
1234 1234 1230 thanks