How to Enable “Precision as Displayed” in Excel 365

Posted on by Summa Lai

Set rounding precision

  1. Click File > Options. …
  2. Click Advanced, and then under When calculating this workbook, select the Set precision as displayed check box, and then click OK.
  3. Click OK.
  4. In the worksheet, select the cells that you want to format.
  5. On the Home tab, click the Dialog Box Launcher.