Formatting Numbers

Sage ERP Accpac General Ledger 6.0

Formatting Numbers

You can change the number format of one or more cells by selecting the cells you want changed, then choosing the Cells command on the Format menu. In the Number tab of the Format Cells dialog box, select a category, then make the desired changes.

The Financial Statement Designer provides a variety of built-in number formats that are available to every financial statement. You can also create your own custom formats. See the Excel online and printed documentation for details.

Formats force rounding

If the format 0.00 is applied to a cell, the Financial Statement Designer rounds the number to two decimal places. If you choose a format with no decimal places, the Financial Statement Designer will also round to fit that format.