Brother International WP1700MDS Owners Manual - English - Page 191

Format, Marks

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

Page 191 highlights

Alphanumeric Data Lw U Alphanumeric data is any combination of characters (letters, digits, and other characters) used as a label to identify the entries of the spreadsheet. It is 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 an alphabetic 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: + - ( 1234567890. it is assumed that this data is to be calculated. In this case, a format mark must be used in order to identify this data as a label and not as a number to be used in a calculation. Format Mark n A Position of the Data Flush left Flush right (gWil + page 176) - see "Help Menus" on Centering (F- 1 + aid - see "Help Menus" on page 176) Format marks are displayed in the input area only. They never appear in the cell. The above characters are considered as format marks only when they are entered 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-1989) 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 justification or centering (A), press [WOE + cj or MI + a 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. 181

  • 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
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.
It
is
usually
as
a
column
heading,
such
as
"JAN."
or
"12th
Region".
This
data
is
not
to
be
cal-
culated.
Format
Marks
If
the
label
data
begins
with
an
alphabetic
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:
+
-
(
1234567890.
it
is
assumed
that
this
data
is
to
be
calculated.
In
this
case,
a
format
mark
must
be
used
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
n
Flush
right
(gWil
+
—
see
"Help
Menus"
on
page
176)
A
Centering
(F
- 1
+
aid
—
see
"Help
Menus"
on
page
176)
Format
marks
are
displayed
in
the
input
area
only.
They
never
appear
in
the
cell.
The
above
characters
are
considered
as
format
marks
only
when
they
are
entered
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-1989)
or
a
phone
number
(e.g.
231-638-7520)
is
not
calculated,
always
use
a
for-
mat
mark.
•
instead
of
typing
the
format
marks
for
right
justification
or
centering
(A),
press
[WOE
+
cj
or
MI
+
a
If
you
press
these
keys
while
in
command
mode,
the
word
processor
switches
to
the
Input/Edit
mode
and
the
corre-
sponding
mark
appears
in
the
Input
Area.
181
w
LU