Decimal Places

We can format numbers in cells for currency, percentages, decimals, dates, phone numbers,…..etc.

  • Select a cell or a cell range.
  • Select “Home” tab.
  • From “Number Group”.
  • For example, select “%”.

Or From the drop-down, select “Percentage”.

Or Select the format you want.


  • Press “CTRL + 1” and select “Number” Tab. Or “Right-click” the cell or cell range, select “Format Cells”, and select “Number” Tab.

Previous: Save in OneDrive

Next: New