HP 95LX - Page 108

Setting the Cell Format Default
This default defines the way each cell in the spreadsheet displays numerical data,
unless it has been differently specified in particular (using (Rjange (Flormat).
Remember that the active cell format for the current cell is listed in the top line
of the display between parentheses— CW), (C22, (D1) are examples.
1. Press (123), (MENU), Worksheet, (GJlobal, (Flormat. You will see a menu with the
format categories shown below.
108
Press the keys corresponding to format options you want (in the list below, n
stands for the number of decimal places you want displayed.
Fixed:
Sci:
Currency:
, (Comma):
General:
Press (F), type n, where n can be from Bto 13.
Example: 5.678904inF2: 3.68
Press (8), type n, where n can be from Bto 15.
Example: 89765.392in 82: 8 .98E+84
Press (C), type n, where n can be from Bto 13.
Example: 89765.392in C2: $89,763.39
Press (7), type n, where n can be from Bto 19.
Example: 89765.392in,2: 89,765.39
Press (G). The normal default setting, it displays all digits except
trailing zeroes after the decimal point. If cell width, it displays in
Scientific Notation to the greatest precision possible.
Example: 5.6789040in G: 2.678904
+/-2 Press (+). Rounds the number to a whole number and then prints that
Percent:
Dte:
number of plus signs (if a positive number), minus signs (if a
negative number), or periods (if the number rounds to zero).
Example: -5.67in+/-; —=—=—=—=—= (six minus signs)
Press (P), type n, where n can be from Bto 13.
Example: 0.2358inP2: 23.98%
Translates the integer portion of a number (between 1 and 73050)
into a date with one of five formats...
Press (0), (1). Example: April 6, 1992 in D1: B&6—Apr-92
Press (D), (2). Example: April 6, 1992 in D2: B6—-Apt-
Press (D), (3). Example: April 6, 1992 in D3: Apr-—92
Press (D), (4). Example: April 6, 1992 in D4: 84/86/92
Press (DJ, (5). Example: April 6, 1992 in D5: 84/86
5. Optimizing Your WORK