Cells that are formatted with the General format have no specific number format. To reset the number format of selected cells, click General in the Category list. Top of Page Tips for displaying percentages For example, if you want to see 10% instead of 10.00%, enter 0 in the Decimal places box. In the Decimal places box, enter the number of decimal places that you want to display. In the Format Cells dialog box, in the Category list, click Percentage. On the Home tab, in the Number group, click the icon next to Number to display the Format Cells dialog box. If you want more control over the format, or you want to change other aspects of formatting for your selection, you can follow these steps. To quickly apply percentage formatting to selected cells, click Percent Style in the Number group on the Home tab, or press Ctrl+Shift+%. Top of Page Display numbers as percentages (If you don't want to display the two zeros after the decimal point, it's easy to get rid of them, as explained in the following procedure.) For example, typing 10 or 0.1 both result in 10.00%. Numbers equal to and larger than 1 are converted to percentages by default and numbers smaller than 1 are multiplied by 100 to convert them to percentages. To learn more about calculating percentages, see Examples of calculating percentages.įormatting empty cells If you apply the Percentage format to cells, and then type numbers into those cells, the behavior is different. If you then format 0.1 as a percentage, the number will be correctly displayed as 10%. For example, if a cell contains the formula =10/100, the result of that calculation is 0.1. Percentages are calculated by using the equation amount / total = percentage. To accurately display percentages, before you format the numbers as a percentage, make sure that they have been calculated as percentages, and that they are displayed in decimal format. For example, if a cell contains the number 10, Excel multiplies that number by 100, which means that you will see 1000.00% after you apply the Percentage format. In this articleĮxample 1: Increase or decrease a number by a percentageĮxample 2: Calculate an amount based on a percentageĮxample 3: Calculate the percentage based on two amountsĮxample 4: Calculate an amount based another amount and a percentageĮxample 5: Calculate the difference between two numbers and show it as a percentageĪlthough formatting numbers as percentages is straightforward, the results you get after you apply the format may vary, depending on whether the numbers already exist in your workbook.įormatting cells that already contain numbers If you apply the Percentage format to existing numbers in a workbook, Excel multiplies those numbers by 100 to convert them to percentages. Learn how to display numbers as percentages in Excel and view examples of several basic techniques for calculating percentages in your worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |