Guía de usuario de Ulet

Primeros pasos con Ulet para {platform}.

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

  1. Open your working expense workbook.

  2. Use an empty area of Expenses: enter Share in F1.

  3. Enter 0.25 in F2 and commit the value.

  4. Select F2, then choose Percent on Home.

  5. Check that the cell displays 25.00%, representing 25 percent.

English worksheet with a Share label and a fractional value displayed as a percentage

View screenshot at full size

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.

Ulet

Tu suite ofimática todo en uno para las tareas diarias.

Ver funciones