Use this cell format When you want to Learn more here
percentage Display numeric values followed
by the % symbol
“Using the Percentage Format in
Table Cells” on page 204
date and time Format how date and time
values are displayed
“Using the Date and Time
Format in Table Cells” on
page 205
duration Format the display of week,
day, hour, minute, second, and
microsecond values
“Using the Duration Format in
Table Cells” on page 205
fraction Format the display of any part
of a value smaller than 1
“Using the Fraction Format in
Table Cells” on page 205
numeral system Format the display of numbers
using the conventions of a
particular numeral system (such
as decimal or binary)
“Using the Numeral System
Format in Table Cells” on
page 206
scientic Format the display of numbers
using an exponent raised by the
power of 10
“Using the Scientic Format in
Table Cells” on page 206
text Display cell content exactly as
you type it
“Using the Text Format in Table
Cells” on page 207
custom Dene your own cell format “Using Your Own Formats for
Displaying Values in Table
Cells” on page 207
Using the Automatic Format in Table Cells
When you add a new cell, its content is displayed using the automatic format.
This content in a cell assigned the automatic
format
Is formatted like this for display
A number Decimal places and commas are preserved
as entered.
For example, 1,000,000.008 displays as
1,000,000.008.
A currency value Decimal places and commas are preserved
as entered.
For example $1,000.0075 displays as $1,000.0075.
A date value The value is preserved as entered and treated
as text, not as a date, in formulas.
For example, 1/1 displays as 1/1.
202 Chapter 9 Working with Table Cells
Comments to this Manuals