A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?

  •  Use the ROUND() function.
  •  Click the Decrease Decimal button twice.
  •  In the cells group on the Home tab, click Format > Format Cells. Then cick the Alignment tab and select Right Indent.
  •  Click the Decrease Decimal button once.

Leave a Reply

Your email address will not be published. Required fields are marked *