How to put 19 digit or more digit number in a excel cell [duplicate]
You can always store the number in the cell as a string. Put an apostrophe in front of the number.
If you change the format of the cell to 'Text', you don't need to prepend an apostrophe; you just put in the number. It will still even be usable as a number by functions that refer to the cell.
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/
Excel seems to allow only 15 digits. What on Earth are you doing that really requires 19 digits of precision? I suspect you're either not stating your problem well or you're worry about unnecessary details.