Brother International WP230B Owners Manual - English - Page 226

Changing, Format, Numeric

Page 226 highlights

4. Freezing affects from column A to the column just before the column that you choose at this step. Place the cursor and press RETURN. An indicator tells you which columns are frozen, for example, if you placed the cursor on column C: A t June :* SUN MON TUE gria -Igq„ ... 2 9 16 23 30 3 10 17 24 4 11 18 25 NOTE: The names of frozen columns are displayed in reverse colors with increased brightness. 5. If you move the cursor to the rightmost columns, you will still see the frozen columns on screen. NOTE: You can freeze only one group of columns at a time. Rows cannot be frozen. Releasing To release the frozen columns-you must release them if you move the cursor into the frozen columns for editing-follow the steps for freezing, but select RELEASE in step (2). A message tells you that the frozen columns have been released: Frozen columns have been released. Changing the Format of Numeric Data This system is quite capable of handling fractional numbers, though it displays the result in decimal numbers. Fractional numbers may even be typed in the Input Area as fractions, but they are displayed on the grid as decimals. The system correctly stores their values. The word processor does not display decimal numbers by default. However, you can change this using the format function to display up to 5 numbers. This function also allows you to display dollar figures with a dollar sign and two decimal places. It also can display percentage data with the percent sign to a specified number of decimal places, again up to five. 214 Spreadsheet

  • 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
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340

4.
Freezing
affects
from
column
A
to
the
column
just
before
the
column
that
you
choose
at
this
step.
Place
the
cursor
and
press
RETURN.
An
indicator
tells
you
which
columns
are
frozen,
for
example,
if
you
placed
the
cursor
on
column
C:
gria
-
Igq„
A
..
................................................................................................................
t
June
:*
SUN
2
9
16
23
30
MON
3
10
17
24
TUE
4
11
18
25
NOTE:
The
names
of
frozen
columns
are
displayed
in
reverse
colors
with
increased
brightness.
5.
If
you
move
the
cursor
to
the
rightmost
columns,
you
will
still
see
the
frozen
columns
on
screen.
NOTE:
You
can
freeze
only
one
group
of
columns
at
a
time.
Rows
cannot
be
frozen.
Releasing
To
release
the
frozen
columns
—you
must
release
them
if
you
move
the
cursor
into
the
frozen
columns
for
editing
—follow
the
steps
for
freezing,
but
select
RELEASE
in
step
(2).
A
message
tells
you
that
the
frozen
columns
have
been
released:
Frozen
columns
have
been
released.
Changing
the
Format
of
Numeric
Data
This
system
is
quite
capable
of
handling
fractional
numbers,
though
it
displays
the
result
in
decimal
numbers.
Fractional
numbers
may
even
be
typed
in
the
Input
Area
as
fractions,
but
they
are
displayed
on
the
grid
as
decimals.
The
system
correctly
stores
their
values.
The
word
processor
does
not
display
decimal
numbers
by
default.
However,
you
can
change
this
using
the
format
function
to
display
up
to
5
numbers.
This
function
also
allows
you
to
display
dollar
figures
with
a
dollar
sign
and
two
decimal
places.
It
also
can
display
percentage
data
with
the
percent
sign
to
a
specified
number
of
decimal
places,
again
up
to
five.
214
Spreadsheet