Format Percentages

We can also use number formatting to format the percentages in column E so they look like percentages.

Drag to select all cells containing numbers in column E.

In Windows, the numbers are formatted as percentages without any decimal places.

Click the Percent Style button on the Formatting toolbar (Windows) or choose Percentage ...

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.