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/126843-not-able-enter-more-than-15-digits-cell.html)

Srinivas Babu Thamada

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

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 10:41 PM.