| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I Calculate Check Digit for UPC A - the 13th warrior | Excel Discussion (Misc queries) | |||
| Sorting by 5 digit & 5 digit plus 4 zip codes | Excel Worksheet Functions | |||
| Excell Check Digit Formula | Excel Worksheet Functions | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
Linear Mode
