Home » Questions » Computers [ Ask a new question ]

How to put 19 digit or more digit number in a excel cell [duplicate]

How to put 19 digit or more digit number in a excel cell [duplicate]

How to put 19 digit or more digit number in a excel cell.

Asked by: Guest | Views: 167
Total answers/comments: 2
bert [Entry]

"When you don't need to calculate with these numbers, you can treat them as text, see the other answers. When you need to calculate with them, then it becomes difficult because Excel has only 15 siginificant digits. The possibilities I know are:

Split the number in 2 (or more) cells. Put a part of the number in one cell and the remainder in another cell. The consequence is that you need to develop your own formules for calculations.
Another solution is using add-in's. For a free one study the articles mentioned in http://www.excel-ticker.com/calculation-of-very-large-numbers-in-excel-part-5-add-in/"
bert [Entry]

"Cause Excel only works with numerics up to 15 digits you have to separate the number and after concatenate

example:

A2 B2 C2
894450360114541404 10000 894450360114551404

=CONCATENATE(LEFT(A2,10),NUMBERVALUE(RIGHT(A2,8))+B2)"
"Cause Excel only works with numerics up to 15 digits you have to separate the number and after concatenate

example:

A2 B2 C2
894450360114541404 10000 894450360114551404

=CONCATENATE(LEFT(A2,10),NUMBERVALUE(RIGHT(A2,8))+B2)"