Brother International PDP350CJ Owner's Manual - English - Page 209

Creating Number and Date Formats You can edit existing formats by clicking the Edit button. Spreadsheet offers a wide variety of standard number and date formats. However, you can create additional number and date formats to suit your needs. For example, if you want to show values with 6 decimal places, you can create a special format. "To create a number or date format: 1. Choose 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 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 set your specifications. S Name of Format. Enter a name for the new format. S Places. Enter the number of decimal places. S Offset. Enter the number of offset places. Negative numbers move the decimal point to the left and positive numbers move it to the right. S Options. Select format options from the drop-down list: commas, percent sign, leading and trailing zeros, and the position of the sign (+ or -) relative to the header or trailer. For example, if the sign follows the header, then a negative dollar amount would be formatted like this: $-100 rather than -$100. S Fixed/Scientific. Select either fixed notation or scientific notation. S Leading. Enter the numbers or characters you want to appear in front of each value you enter, like a prefix. 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; if you enter 345, it will appear as DM345 in the active cell. Spreadsheet 195