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.
Or
- Press “CTRL + 1” and select “Number” Tab. Or “Right-click” the cell or cell range, select “Format Cells”, and select “Number” Tab.
