Brother International WP230B Owners Manual - English - Page 201

Alphanumeric

Get Brother International WP230B PDF manuals and user guides View all Brother International WP230B manuals
Add to My Manuals
Save this manual to your list of manuals

Page 201 highlights

Alphanumeric Data Alphanumeric data is any combination of characters (letters, digits, and other characters) used as a label to identify the entries of the spreadsheet, usually as a column heading, such as "JAN." or "12th Region." This data is not to be calculated. Format Marks If the label data begins with a letter, it is assumed that this data is not to be calculated. In this case, the data is placed flush left in the cell unless a flush right or centering format mark is used. If the label begins with any of the following: + ( 1 234567890 it is assumed that this data is to be calculated. In this case, you must use a format mark in order to identify this data as a label and not as a number to be used in a calculation. Format Mark ll A Position of the Data Flush left Flush right (CODE + R)-see Help Menus on page 184 Centering (CODE + F)-see Help Menus on page 184 Format marks appear in the input area only. They never appear in the cell. The above characters are considered as format marks only when you enter them in the first position of the input area. If they are entered in the middle of the data, they are considered as common characters and will appear in the cell. NOTES: • To make sure that alphanumeric data such as a date (e.g., 10-12-1996) or a phone number (e.g., 231-638-7520) is not calculated, always use a format mark. • Instead of typing the format marks for right alignment (") or centering (^), press CODE + R or CODE + F. Ifyou press these keys while in commandmode, the wordprocessor switches to the Input/Edit mode and the corresponding mark appears in the Input Area. Spreadsheet 189

  • 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
Alphanumeric
Data
Alphanumeric
data
is
any
combination
of
characters
(letters,
digits,
and
other
characters)
used
as
a
label
to
identify
the
entries
of
the
spreadsheet,
usually
as
a
column
heading,
such
as
"JAN."
or
"12th
Region."
This
data
is
not
to
be
calculated.
Format
Marks
If
the
label
data
begins
with
a
letter,
it
is
assumed
that
this
data
is
not
to
be
calculated.
In
this
case,
the
data
is
placed
flush
left
in
the
cell
unless
a
flush
right
or
centering
format
mark
is
used.
If
the
label
begins
with
any
of
the
following:
+
(
1
2
3
4
5
6
7
8
9
0
it
is
assumed
that
this
data
is
to
be
calculated.
In
this
case,
you
must
use
a
format
mark
in
order
to
identify
this
data
as
a
label
and
not
as
a
number
to
be
used
in
a
calculation.
Format
Mark
Position
of
the
Data
Flush
left
ll
Flush
right
(CODE
+
R)
—see
Help
Menus
on
page
184
A
Centering
(CODE
+
F)
—see
Help
Menus
on
page
184
Format
marks
appear
in
the
input
area
only.
They
never
appear
in
the
cell.
The
above
characters
are
considered
as
format
marks
only
when
you
enter
them
in
the
first
position
of
the
input
area.
If
they
are
entered
in
the
middle
of
the
data,
they
are
considered
as
common
characters
and
will
appear
in
the
cell.
NOTES:
•
To
make
sure
that
alphanumeric
data
such
as
a
date
(e.g.,
10-12-1996)
or
a
phone
number
(e.g.,
231-638-7520)
is
not
calculated,
always
use
a
format
mark.
•
Instead
of
typing
the
format
marks
for
right
alignment
(")
or
centering
(^),
press
CODE
+
R
or
CODE
+
F.
If
you
press
these
keys
while
in
command
mode,
the
word
processor
switches
to
the
Input/Edit
mode
and
the
corresponding
mark
appears
in
the
Input
Area.
Spreadsheet
189