HP Palmtop 620X, Palmtop 660LX manual Entering values, To format a cell as text, Formatting numbers

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 - ( )

WorkingwithHPrePalm-InstalledopPCApplicationsUserGuide-77