Operation Manual

102 | Working with Tables
Formatting mbers nu
The Tabl text toolbar includes additional buttons, switched on with
et f
disp t you add commas and currency signs to
numbers, express numbers as percents, control how many decimal places are
e con
the Spreadshe unctions button, which let you vary how numbers are
layed. Number formats le
displayed, etc. Number formats do not
alt umbers internally—only the wa
nu bers are displayed.
er n y
m
• Click the Remove Formatting button to remove any formatting.
• Click the Currency button to apply the currency format and symbol
for your locale as suggested by Windows.
• Click the Percent button to convert a number to a percentage
(multiply by 100 and append a percent sign).
• Click the Comma button to separate thousands by a comma and
remove decimal places.
• Click the Increase Decimal or Decrease Decimal button to
number of decimal places shown.
ptions:
•
extend or reduce the
For additional number formatting o
Click the Custom Format button.
The Custom Form
listed format
you wish), and
symbol charac cale, as supplied by
W ows.
To apply a f
1. Select it i
negative v
2. Click OK
To specify a custom format:
1. e it i bols.
(As you ty ts any matching
entries.)
atting dialog appears. Here you can select from any of the
s, construct custom formats (with colour for negative values, if
customize the list. The built-in list includes two currency
ters (one positive, one negative) for your lo
ind
ormat to the current cell:
n the list. The Sample box provides a preview of positive and
alues using the format.
.
Typ nto the box below the list, using any of the following sym
pe the list automatically scrolls and highligh