Home |
Search |
Today's Posts |
#1
|
|||
|
|||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO
when typing a credit card number with 16 digits the last digit always returns
as a zero. Is there a way around this. |
#2
|
|||
|
|||
You will have to format it as text. Excel only supports 15 signifcant
figures. (Many computer programs have this limitation.) Try formatting the cells as text before you type the numbers in. tj "jnkell" wrote: when typing a credit card number with 16 digits the last digit always returns as a zero. Is there a way around this. |
#3
|
|||
|
|||
Hi
and another option would be to precede your entry with an apostrophe. e.g. '1234567890123456 -- Regards Frank Kabel Frankfurt, Germany jnkell wrote: when typing a credit card number with 16 digits the last digit always returns as a zero. Is there a way around this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Counting multiple numbers in one cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
combining several individual cells of numbers into one cell | Excel Worksheet Functions |