ExcelBanter - Not able to enter more than 15 digits in a cell.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Not able to enter more than 15 digits in a cell. (https://www.excelbanter.com/excel-discussion-misc-queries/126745-re-not-able-enter-more-than-15-digits-cell.html)

Mike

Not able to enter more than 15 digits in a cell.

You can only display a number of this size as text. See

http://support.microsoft.com/kb/269370

"Srinivas Babu Thamada" wrote:

I am trying to enter a 20 digit number into a cell but the last 5 digits are
being converted to zeros. I would like the cell to display all the digits as
I entered and these should be used for calculations based by my defined
formulas.

All times are GMT +1. The time now is 07:42 AM.