| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to enter more than 20 digit numbers in one cell
I want to add just 20 digit number in one cell but whenever I try to type 13080048062000000030 I get 13080048062000000000
What is the problem ? Presently I am just putting '13080048062000000030. It just forces it in text format but I have not solved the original problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering 16 digit numbers in cell | New Users to Excel | |||
| can't enter a num. in xl cell, which is more than 16 digit or lon | Excel Discussion (Misc queries) | |||
| how can I enter a 21 digit number in a cell & keep it from change | Excel Discussion (Misc queries) | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Threaded Mode
