User Guide

Chapter 4 Working with Table Cells 87
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 dene a cell format, you can associate the format with multiple cells by using m
autolling. See “Autolling Table Cells” on page 78 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 88
number Format the display of a
number’s decimal places,
thousands separator, and
negative values
“Using the Number Format in
Table Cells” on page 89
currency Format the display of monetary
values
“Using the Currency Format in
Table Cells” on page 90
percentage Display numeric values followed
by the % symbol
“Using the Percentage Format in
Table Cells” on page 91
date and time Format how date and time
values are displayed
“Using the Date and Time
Format in Table Cells” on
page 92
duration Format the display of week,
day, hour, minute, second, and
microsecond values
“Using the Duration Format in
Table Cells” on page 93
fraction Format the display of any part
of a value smaller than 1
“Using the Fraction Format in
Table Cells” on page 93
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 94
scientic Format the display of numbers
using an exponent raised by the
power of 10
“Using the Scientic Format in
Table Cells” on page 95
text Display cell content exactly as
you type it
“Using the Text Format in Table
Cells” on page 96
cell controls (checkboxes, slider,
stepper, or pop-up menu)
Control the specic values a cell
can contain
“Using a Checkbox, Slider,
Stepper, or Pop-Up Menu in
Table Cells” on page 96
custom Dene your own cell format “Using Your Own Formats for
Displaying Values in Table
Cells” on page 98