Manual

Creating Number and Date Formats
While Spreadsheet offers a wide variety of standard number and date formats,
you can create additional number and date formats to suit your needs. For
example, if you want to show values with six decimal places, you can create
a special format.
New formats appear at
the end of the list in the
dialog box.
)_ To create a number or date format:
1. Select Number Format from the Properties menu. A dialog box appears.
2. Select a format on which you can base the new format. For example, if
you want to create a format for displaying numbers with six decimal
places, you might pick Fixed and specify six decimal places.
3. Click on Create. The Define Format dialog box appears.
4. Fill in the dialog box, selecting the options you want. Refer to the
examples in the dialog box as you make your selections.
• Name of Format. Enter a name for the new format.
• Places. Enter the number of decimal places.
• Offset. Enter the number of offset places. Negative numbers move
the decimal point to the left, and positive numbers move it to the
right.
• Options. Select format options from the drop-down list: commas,
percent sign, leading and trailing zeros, and the position of the sign
(+ or -) relative t.o.the leader or trailer. For example, if the sign
foll6ws _e_:iea'der,-Tth-en a negative dollar amount would be
formatted like this: $-100 rather than -$100.
• Fixed/Scientific. Select either fixed notation or scientific notation.
Leading. Enter the numbers or characters you want to appear in
front of each value you enter, like a prefLX. YOU can specify a prefix
for Positive, Negative, or All Numbers. For example, if you enter DM
in the All box, every value using this format will begin with DM; then
if you enter 345, it will appear as DM345 in the active cell.
Trailing. Enter the numbers or characters you want to appear at the
end of each value you enter, like a suffix. For example, if you enter
DM in the All box, DM will appear at the end of every value using
this format; then if you enter 345, it will appear as 345DM in the
active cell.
5. Click on OK. The new fomru, t is saved with the spreadsheet.
Spreadsheet 116