Select any formatted cell to display the original unformatted number in the formula bar above the worksheet.Īpply Percent Formatting Using Ribbon Options.The numbers in the selected cells are formatted to display the percent symbol.To apply percent formatting to data using shortcut keys: The formats applied to the selected number data using shortcut keys are: The key combination that can be used to apply number formatting to data is Ctrl+ Shift+ % (percent symbol). With the exception of the number 1, integers (numbers with no decimal portion) are not normally formatted for percent because the displayed values are increased by a factor of 100.Īpply Percent Formatting Using Shortcut Keys For example, 0.33 which, when formatted for percent, displays as 33%. In the dialog box, select Currency in the category list on the left-hand side to view or change the current settings.Įnsure that data displayed in percent format is entered in decimal form.
It's the small downward pointing arrow in the bottom right corner of the Number group. The Format Cells dialog box is opened one of two ways: The currency format in the Format Cells dialog box is very similar to the number format, except for the option to choose a different currency symbol from the default dollar sign. The main difference between the two is that the Accounting format aligns the dollar sign on the left side of the cell while aligning the data on the right.Īpply Currency Formatting in the Format Cells Dialog Box It is for the Accounting format as shown in the image above. The dollar sign ( $ ) icon located in the Number group on the Home tab, is not for the Currency format.
Number formatting does not change the actual number in the cell, just the way it appears.įor example, select a cell that has been formatted for negative, special, or long numbers and the plain number rather than the formatted number displays in the formula bar above the worksheet. Number formatting is attached to the cell and not to the value in the cell. Number formatting in Excel changes the appearance of a number or value in a cell in the worksheet.