Operation Manual

Working with Tables | 103
n
r than #'s specified, then the extra digits left of the
0
A
igits in
e separator will be displayed.
-
D ymbol
+
D mbol if the number is positive, or a
the number is negative.
e)
olour]
.g. Red.
ack, White,
een, Mustard, Dark Blue, Purple,
e formats:
RGB(xxx,yyy,zzz), CMYK(www,xxx,yyy,zzz), or
.
Decim
%
D
/
D
0
D o decimal places, e.g. 0.4 as 0. Same as entering 0.#
(or having no format at all).
isplayed, e.g. 0.4 as 0.4
n exponential (or scientific format), e.g. 0.4
" character to specify the number
of decimal places shown before or after the exponent, e.g. the
#
Display a digit if the number has one. If there are more digits i
the numbe
decimal place separator will be displayed.
lways displays a digit. If a number does not have a digit in this
position then a zero (0) is displayed. If there are more d
the number than 0's specified, then the extra digits left of the
decimal plac
isplay a negative symbol if the number is negative. No s
is displayed if the number is positive.
isplay a positive sy
negative symbol if
(cod
Display the formatted number in parentheses if the number is
negative.
[c
Display a negative number in the specified colour, e
You can type any of these colour names: None, Bl
Grey, Grey, Red, Green, Blue, Yellow, Orange, Cyan,
Magenta, Burgundy, Dark Gr
Sea Green
OR
You can enter colour values using one of thes
HSL(xxx,yyy,zzz)
al separator
isplay numbers as percentages, e.g. 0.4 as 40% or 1.25 as
125%
isplay decimal places as fractions, e.g. 0.4 as 2/5
isplay n
0.0
Display one decimal place, e.g. 0.4 as 0.4
0.00
Displays two decimal places, e.g. 0.4 as 0.40
0.
Automatically calculate the number of decimal places to be
d
e
Display number as a
as 4e-01. You can use the "0