Forum Discussion
How many digits can I enter in a cell for a multiplication
When I enter 123,456,789 times 123,456,789 the solution comes as: 15,241,578,750,190,500 The result is wrong. Why is this result appearing?
ThanksSubodh_Tiwari_sktneer
With the format as Number, I can only enter 15 digits and then Excel changes all the digits that follow to "0"
Therefore, if I want to make a multiplication that results in more than 15 digits I don't have the complete result. Do you know how to make a multiplication that will result in more than 15 digits?
That's correct. https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3.
Btw if you only have to enter a large number in a cell i.e. a number with more than 15 digits, you may format the cell as Text and you can enter a number with more than 15 digits. But in your calculations, the 15 digits limit comes into play.