Cells [Format menu] (Financial Statement Editor)

Show expandable text

Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

Open the Format Cells dialog to specify the fonts to be used for a selected cell or group of cells within the financial statement, to specify how numbers are to be displayed, and to specify alignments.

From the Financial Statement Editor, highlight a cell or group of cells and choose Format > Cells.

Note: You can also open the Format Cells dialog from the Statement Format tab of the Setup > New Statement Defaults dialog, to specify default settings for the Header, Body, or Footer section.

Tabbed pages in this dialog

Font tab
Choose from the options on the Font tab of the Format Cells dialog to change the appearance of the text in the selected cell(s). You may specify the typeface, style, size, the type of underlining, and the color. By marking the appropriate checkbox, you may also choose to select strikethrough text or all uppercase letters.

Number tab
Use the drop-down list fields in the Number tab to define how the numbers should appear in the selected cell(s).

  • Choose how the $ or % symbol is to be displayed (none, floating $, fixed $, or standard %).
  • Specify how negative numbers are to be displayed (negative sign, negative sign-red, parentheses, parentheses-red).
  • Specify the decimal precision to use (from 0 to 5 decimal places).
  • Define how zero amounts are to be shown (0.00, blank, or dash).
    About using decimal precision of zero in a column or cell

Alignment tab
Use the Alignment tab to specify where in the cell data should appear. You can specify the horizontal and vertical alignments as well as the distance to indent.

Was this article helpful?

Thank you for the feedback!