Adding more than 15 digits in excel

Posted by user111921 on Super User See other posts from Super User or by user111921
Published on 2012-01-03T04:38:03Z Indexed on 2012/10/08 3:39 UTC
Read the original article Hit count: 159

Filed under:

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.

Please recommend 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.

with out using ' before value is there any other way to keep value same.

© Super User or respective owner

Related posts about excel-2003