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?
Excel converts it to
1.23457E+19 in general format.
' before the value, is there any other way to keep value same?