To change number formatting using the formatting icons
· You can quickly change the formatting of a cell or selected range by using the following icons on the Formatting toolbar.
| Currency | 12345 will become $12,345.00 |
| Percent | .25 will become 25% |
| Comma | 98765 will become 98,765.00 |
| Increase Decimal | 12,345.00 will become 12,345.000 |
| Decrease Decimal | 98,765.00 will become 98,765.0 |
· Select the cell or range of cells you want to format.
· From the Format menu, click Cells.
· From the Format Cells dialog box displayed, select the Number tab.
· In the Category: section, select Currency.
· Select the number of decimal places you require by using the Decimal places: spin box arrows.
· In the Symbol: section drop down list, select the type of currency.
· Click OK.
To format a number as a percentage
· Select the cell or range of cells you wish to format.
· From the Format menu, click Cells.
· From the Format Cells dialog box displayed, select the Number tab.
· In the Category: section, select Percentage.
· Select the number of decimal places you require by using the Decimal places: spin box arrows.
· Click OK.
0 comments:
Post a Comment