Brother International WP7550JPLUS Owner's Manual - English - Page 119

Fixed, Currency

Page 119 highlights

Fixed Currency This function is used to control the number of decimal places that will be displayed and allows you to use commas to separate the thousands. The default is an Auto mode which displays up to 5 decimal digits. The setting does not affect the number of decimal places that are actually stored in the memory. 1. Move the cursor to a corner of the range of cells that you want to format and press MENU and select Style; then select Fixed from the function menu. 2. Proceed as you would with the Underline function to select the range of cells. After the range is selected, the FIXED window appears: « FIXED » FIXED DISPLAY: SEPARATOR: NO DECIMAL PLACES [0 Press SPACE to change setting and press RETURN_ 3. Use CURSOR UP and CURSOR DOWN to move the cursor to the desired setting. Use SPACE BAR to alternate between YES and NO. Use the numeric keys to set the number of decimal places. • FIXED DISPLAY: YES Cancels the settings of Currency and Percent, and enables the setting of the FIXED window. • FIXED DISPLAY: NO Cancels the Fixed setting in the designated range and returns the default Auto mode. • SEPARATOR: YES Displays the numeric values with commas separating the thousands (for example, 1,234,567). • SEPARATOR: NO Displays the numeric values without commas. • DECIMAL PLACES: 0-5 Displays the numeric value with the specified numbei of decimal places. If a numeric. value has inure decimal digits, it is rounded. If it has less, zeroes are added to the right. 4. Press RETURN when finished. This function automatically adds a dollar symbol $ to the left of numeric data. Like the Fixed function, it controls the number of decimal digits and separates the thousands by commas automatically. The function can also hide zero values. 1. Move the cursor to a corner of the range of cells that you want to add a dollar symbol and press MENU and select Style; then select Currency from the function menu_ 2. Proceed as you would with the Underline function, to select the range of cells. After the range is selected, the CURRENCYwindow appears: « CURRENCY >> CURRENCY DISPLAY: ZERO DISPLAY: SEPARAT OR: DECIMAL PLACES [0 - St: Irgel YES NO 2 Press SPACE to change setting and press RETURN. Spreadsheet 111

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252

Fixed
This
function
is
used
to
control
the
number
of
decimal
places
that
will
be
displayed
and
allows
you
to
use
commas
to
separate
the
thousands.
The
default
is
an
Auto
mode
which
displays
up
to
5
decimal
digits.
The
setting
does
not
affect
the
number
of
decimal
places
that
are
actually
stored
in
the
memory.
1.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
format
and
press
MENU
and
select
Style;
then
select
Fixed
from
the
function
menu.
2.
Proceed
as
you
would
with
the
Underline
function
to
select
the
range
of
cells.
After
the
range
is
selected,
the
FIXED
window
appears:
Currency
«
FIXED
»
FIXED
DISPLAY:
SEPARATOR:
DECIMAL
PLACES
[0
NO
Press
SPACE
to
change
setting
and
press
RETURN_
3.
Use
CURSOR
UP
and
CURSOR
DOWN
to
move
the
cursor
to
the
desired
setting.
Use
SPACE
BAR
to
alternate
between
YES
and
NO.
Use
the
numeric
keys
to
set
the
number
of
decimal
places.
FIXED
DISPLAY:
YES
Cancels
the
settings
of
Currency
and
Percent,
and
enables
the
setting
of
the
FIXED
window.
FIXED
DISPLAY:
NO
Cancels
the
Fixed
setting
in
the
designated
range
and
returns
the
default
Auto
mode.
SEPARATOR:
YES
Displays
the
numeric
values
with
commas
separating
the
thousands
(for
example,
1,234,567).
SEPARATOR:
NO
Displays
the
numeric
values
without
commas.
DECIMAL
PLACES:
0-5
Displays
the
numeric
value
with
the
specified
numbei
of
decimal
places.
If
a
numeric.
value
has
inure
decimal
digits,
it
is
rounded.
If
it
has
less,
zeroes
are
added
to
the
right.
4.
Press
RETURN
when
finished.
This
function
automatically
adds
a
dollar
symbol
$
to
the
left
of
numeric
data.
Like
the
Fixed
function,
it
controls
the
number
of
decimal
digits
and
separates
the
thousands
by
commas
automatically.
The
function
can
also
hide
zero
values.
1.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
add
a
dollar
symbol
and
press
MENU
and
select
Style;
then
select
Currency
from
the
function
menu_
2.
Proceed
as
you
would
with
the
Underline
function,
to
select
the
range
of
cells.
After
the
range
is
selected,
the
CURRENCY
window
appears:
«
CURRENCY
>>
CURRENCY
DISPLAY:
ZERO
DISPLAY:
SEPARAT
OR:
DECIMAL
PLACES
[0
-
St:
Irgel
YES
NO
2
Press
SPACE
to
change
setting
and
press
RETURN.
Spreadsheet
111