| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while entering credit card numbers last number changes to zero
I am entering credit card numbers in a column and I notice the very last
digit keeps changing to zero. I have the cell unlocked. Any suggestiong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
while entering credit card numbers last number changes to zero
Excel only allows number precision up to 15 digits. After the 15th digit
Excel changes those digits to 0 as you've experienced. Enter the CC numbers as TEXT. Either preformat the cell as TEXT or precede the entry with an apostrophe like this: '1234567890123456. The apostrophe will not be displayed in the cell. -- Biff Microsoft Excel MVP "dreamer" wrote in message ... I am entering credit card numbers in a column and I notice the very last digit keeps changing to zero. I have the cell unlocked. Any suggestiong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i show only the last four digits of a credit card number | Excel Discussion (Misc queries) | |||
| Credit Card Number | Excel Worksheet Functions | |||
| Credit Card Number | Excel Worksheet Functions | |||
| why does excel change last digit of credit card numbers to zero? | New Users to Excel | |||
| Format for credit card numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
