
If you delete a value from a cell with a format, the cell’s format isn’t deleted. To m
delete the format, apply the automatic format. To delete the value and format, choose
Edit > Clear All.
After you dene a cell format, you can associate the format with multiple cells by using m
autolling. See “Autolling Table Cells” on page 81 for instructions.
To see the unformatted content in a cell to which formatting has been applied, select m
the cell and view the actual value in the formula bar.
Use this cell format When you want to Learn more here
automatic Automatically format content
based on the characters it
contains
“Using the Automatic Format in
Table Cells” on page 91
number Format the display of a
number’s decimal places,
thousands separator, and
negative values
“Using the Number Format in
Table Cells” on page 92
currency Format the display of monetary
values
“Using the Currency Format in
Table Cells” on page 93
percentage Display numeric values followed
by the % symbol
“Using the Percentage Format in
Table Cells” on page 94
date and time Format how date and time
values are displayed
“Using the Date and Time
Format in Table Cells” on
page 95
duration Format the display of week,
day, hour, minute, second, and
microsecond values
“Using the Duration Format in
Table Cells” on page 96
fraction Format the display of any part
of a value smaller than 1
“Using the Fraction Format in
Table Cells” on page 96
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 97
scientic Format the display of numbers
using an exponent raised by the
power of 10
“Using the Scientic Format in
Table Cells” on page 98
text Display cell content exactly as
you type it
“Using the Text Format in Table
Cells” on page 99
cell controls (checkboxes, slider,
stepper, or pop-up menu)
Control the specic values a cell
can contain
“Using a Checkbox, Slider,
Stepper, or Pop-Up Menu in
Table Cells” on page 99
custom Dene your own cell format “Using Your Own Formats for
Displaying Values in Table
Cells” on page 101
90 Chapter 4 Working with Table Cells
Kommentare zu diesen Handbüchern