I want to add more than 20 digits in an Excel cell.
The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I enter more than 15 digits it gets converted to 0's.
What are the recommended steps for stopping Excel from converting data to exponential Format for 20 digits when in the general format?
Example: 12345678901234567890
Excel converts it to 1.23457E+19 in general format.
Without using ' before the value, is there any other way to keep value same?
Best Answer
Some numbers are displayed in exponential format if the column is too narrow and you can fix this by increasing the width of the column.
However, very large numbers in Excel are stored in floating point format and cannot be represented in Excel exactly. You may be able to override their display using cell formatting but the true values will still be stored and processed using floating point arithmetic, with its inherent limitations.
If you need to perform calculations with greater precision you need an application that supports arbitrary precision arithmetic.