HP 620Lx HP 620LX/660LX PalmTop - (English) User Guide - Page 87

Entering values, Formatting text, To format a cell as text, Formatting numbers

Get HP 620Lx - Palmtop PC PDF manuals and user guides View all HP 620Lx manuals
Add to My Manuals
Save this manual to your list of manuals

Page 87 highlights

Entering values Pocket Excel recognizes two types of data: values (constant text and numbers) and formulas (a sequence of values, cell references, names, functions, or operators, that produces a new value from existing values). This section deals with values. For information on formulas, see the next section, "Using functions and formulas." When you enter a value, Pocket Excel determines its data type based on what you type. Then, Pocket Excel applies the default format for that type of entry: text, date, time, currency value, or percentage. ! Note Although Pocket Excel automatically formats your entries, you can change the formats as needed. Formatting text A cell formatted as text can have up to 255 characters and is left-aligned by default. You can include in this cell any combination of nonnumeric characters, numbers, and spaces, such as: A-Z a-z Sometimes you may want to treat a number as text (for example, you want the leading zero in a postal code to be displayed). If you format a cell as text, Pocket Excel will not alter any number you enter into it. To format a cell as text 1. Select the cell. 2. On the Format menu, tap Cells. 3. On the Number tab, select Text from the Category list. 4. Tap OK. Formatting numbers Numbers are entered as constant values and are right-aligned in the cell by default. Numbers can include numeric characters (0 through 9) and any of the following special characters E e - ( ) WorkingwithHPPrPe-aIlnmstaolplePdCAUppsleircaGtuioidnes- 77

  • 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
HP Palmtop PC User Guide - 77
WorkingwithPre-InstalledApplications
Entering values
Pocket Excel recognizes two types of data: values (constant text and numbers)
and formulas (a sequence of values, cell references, names, functions, or opera-
tors, that produces a new value from existing values). This section deals with
values. For information on formulas, see the next section, “Using functions and
formulas.”
When you enter a value, Pocket Excel determines its data type based on what you
type. Then, Pocket Excel applies the default format for that type of entry: text,
date, time, currency value, or percentage.
Note
Although Pocket Excel automatically formats your entries, you can change the
formats as needed.
Formatting text
A cell formatted as text can have up to 255 characters and is left-aligned by de-
fault. You can include in this cell any combination of nonnumeric characters,
numbers, and spaces, such as:
A-Z a-z< > ? ‘“ ; { } [ ] | \ _ * & ^ # @ ! ‘ ~ % ,
Sometimes you may want to treat a number as text (for example, you want the
leading zero in a postal code to be displayed). If you format a cell as text, Pocket
Excel will not alter any number you enter into it.
To format a cell as text
1. Select the cell.
2. On the Format menu, tap Cells.
3. On the Number tab, select Text from the Category list.
4. Tap OK.
Formatting numbers
Numbers are entered as constant values and are right-aligned in the cell by
default. Numbers can include numeric characters (0 through 9) and any of the
following special characters:
+ / $ , % . E e - ( )
!