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: 164
excel-2003
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