Display Spreadsheet Values as Percentages on Windows
A percentage format displays a fraction as a value out of 100. For example, the numeric value 0.25 represents 25 percent.
For matching example data, use the Practice workbook section at the end of this guide.
Create a percentage example
Open your working expense workbook.
Use an empty area of Expenses: enter Share in F1.
Enter 0.25 in F2 and commit the value.
Select F2, then choose Percent on Home.
Check that the cell displays 25.00%, representing 25 percent.

A fractional input of 0.25 is displayed as 25 percent.
Choose the correct input
Entering 25 and then applying a percentage format would represent 2500 percent. Decide whether your source supplies a fraction such as 0.25 or an already expressed percentage.
Use decimal places appropriate to the information. Extra decimal places can be useful for a small difference, but they do not make an imprecise source more accurate.
Keep the format with the value
Press Ctrl+S and reopen the working file. Check both the percentage display and the meaning of the input before copying the value to another calculation.
Practice workbook
To reproduce this example, start with a separate practice copy. On Ulet Home, choose Sheets. Rename the first worksheet Expenses and enter the following values in A1:E6. Enter amounts as numbers.
Item | Amount | Category | Owner | Status |
|---|---|---|---|---|
Paper | 12 | Supplies | Alex | Complete |
Pens | 8 | Supplies | Sam | Complete |
Desk lamp | 45 | Equipment | Jordan | Planned |
Notebook | 15 | Supplies | Alex | Planned |
Storage box | 20 | Equipment | Sam | In progress |
Enter Total in A7 and =SUM(B2:B6) in B7. The initial total is 100. Column widths, colors, and number formatting are presentation choices; the values and cell addresses are what the exercise depends on.
Press Ctrl+Shift+S to choose a practice folder and save as Riverside-Expense-Tracker.xlsx. Reopen this named copy before following the exercise above. Keep your original documents separate.

