Report Designer: Format > Cells dialog

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

Use the Format Cells dialog to modify format settings for selected cells within the design grid, including the font type, size, and style; number, amount, percentage, and date/time settings; alignments; and borders for selected cells.

In the Report Designer, choose Format > Cells.

Tabbed pages in this dialog

Select the font type, size, style, color, and font effects for text within the selected cells.

Select a category that best describes the contents of the selected cells and customize them according to your needs.

Use the Format tab of the Format Cells dialog to define your cell(s) using one of the following categories:

  • General. No specific format associated with this category
Number or Amount
  • You can specify the following formatting options for repeating and non-repeating numbers and amounts.
    • Rounding applied for an single report with decimals turned off: If you choose as the decimal format, rounding is applied individually to the whole number. The application rounds up based on the assumption that the number is greater than or equal to 50. (For example, the result in a report for an amount of $120.51, displays as $121 on the report with rounding applied.)
    • Rounding applied for the client with decimals turned off: If you apply rounding for the client from the Balance tab of the Setup > Clients > Accounting Information screen, the application rounds the debit and credit balances for each period, and then combines them. (For example, the result in a report for an amount of $120.51, may display as $120 on the report with rounding applied.)

      For more information, see Rounding on reports and financial statements

    • Dollar sign. Define how the $ symbol is to be displayed (none, floating $, fixed $, non-repeating floating $, or non-repeating fixed $)

      Show me.

      In the following examples, dollar signs are depicted in red font for clarity.

      Format Example
      Floating $ floating dollar sign
      Fixed $ fixed dollar sign
      Non-repeating floating $ non-repeating floating dollar sign
      Non-repeating fixed $ non-repeating fixed dollar sign
    • Negative amounts. Define how negative numbers are to be displayed (negative sign, number in parentheses, red numbers, negative sign and red numbers, red numbers in parentheses)
    • Zero amounts. Define how zero amounts are to be shown (blank, zero, dash, N/A)
    • Choose to use 1000 separator (,), divide the number by 1000, multiply by -1, use a zero when there is no data; specify number type (numeric, ordinal numbers, words, or ordinal words).
  • Percentage. You can specify the following formatting options for repeating percentages and non-repeating percentages.
    • Decimal places. Precision (from 0 to 15 decimal places).
    • Percent sign. Define how the % symbol is to be displayed (none, floating %, fixed %, non-repeating floating %, or non-repeating fixed %).

      Show me.

      In the following examples, percent signs are depicted in red font for clarity.

      Format Example
      Floating % floating percent sign
      Fixed % fixed percent sign
      Non-repeating floating % non-repeating floating pecent sign
      Non-repeating fixed % non-repeating fixed percent sign
    • Negative amounts. Define how negative numbers are to be displayed (negative sign, number in parentheses, red numbers, negative sign and red numbers, red numbers in parentheses).
    • Zero amounts. Define how zero amounts are to be shown (blank, zero, dash, N/A).
    • Choose to use 1000 separator (,), multiply the number by 100, multiply by -1, use a zero when there is no data.
  • Date. Select a date format from a pre-defined list.
  • Period. You can specify how you want to display the posting period presentation (numeric, ordinal numbers, words, or ordinal words).

Select the horizontal/vertical alignments and indent settings for the content of the selected cells.

Add, modify, or remove tab stop positions for a letter. (The default stop position is 1 inch and the tab stops setting is 0.5 inches and cannot be changed.)

Use the Border tab to select a color, line style, and to determine how the borders will appear for selected cells in the report.

Was this article helpful?

Thank you for the feedback!