the decimal place problem in excel

So this is not the default behaviour in Excel. This loss of number precision is caused by a workbook-specific setting called Set precision as displayed.

The setting is shown here in the Options -> Advanced -> When calculating this woorkbook section:

Setting for Set precision as displayed

Turning this on for a workbook will cause precision to automatically be reduced to what is visible in the workbook.

The setting is disabled\off by default and is described in more detail here. From the docs:

Permanently changes stored values in cells from full precision (15 digits) to whatever format is displayed, including decimal places.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top