Format Cells - Format Tab

Access this tab using Activities>Budget Worksheet>Right-Click>Format Cells.

Use this tab to specify the format of the selected cells by choosing from one of the available Format Types. For example, you might want to change the Effective Date column to display in DD-MMM-YY format, which shows 12/1/00 as 01-Dec-00.

Note that a cell's format can only be changed within the constraints of the data displayed in that cell. For example, a date cell cannot be formatted with a Format Type of "Dollars."

The changes made to the date and dollar formats will affect the data, since you are changing the actual data and not just its appearance. For example, if you change from MM/DD/YY to MMM-YY, the new format will appear when the worksheet is printed. Similarly, if you select to display more decimal points in the dollar cells (using the Precision box), the additional decimal points will appear on the printout.

 

Format Type: Specify the format of the selected cells by choosing from one of the available format types.

Precision: Set the precision for format types that involve numeric data. This specifies the number of decimal places displayed; enter the number that indicates how many places to the right of the decimal you want to display.