I want to add more than 20 digits in an Excel cell. The current format of the cell is general, and 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 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.
Excel converts it to 12345678901234500000 in number & accounting format.