Microsoft Office Tutorials and References
In Depth Information
Changing Cell Formats
Changing Cell Formats
You can change the size or appearance of
any cell regardless of content. For example, by
default, values are displayed as general numbers;
however, you can choose to display values as
currency, percentages, fractions, dates, and many
other formats. You can make your titles large and
bold so they are quickly noticed.
Accounting Number Format Number Format
Percent Style Comma Style
Formatting Values
The Excel Ribbon provides several methods you
can use for formatting values. First, there are
buttons on the Home tab of the Ribbon that include
several popular number styles: accounting,
percentages, and commas. You can also choose from
the Number Format drop-down menu, or you can
open the Format Cells dialog box where you’ll see
all available options.
Figure 10-1
Numeric values formatted with different styles.
Select the cells you want formatted. You can select
a few cells, entire rows, entire columns, or the
entire worksheet. Choose Home>Number and
select from the following options (see Figure 10-1):
Accounting Number Format: The
Accounting option has a drop-down menu
from which you can select international
currency symbols.
Percent Style: When changing numbers to
display as a percentage, Excel automatically
multiplies the cell value by 100 and displays
the result with a percent symbol and no
decimal points. For example, if the cell has
a value of 15, Excel displays 1500%;
however, if the cell has a value of 0.15, Excel
displays 15%.
Search JabSto ::

Custom Search