Format values as percentages. To show a number as a percent in Excel, you need to apply the Percentage format to the cells. Simply select the cells to format, and then click the Percent Style (%) ...