Column Format Options

Individual columns can be formatted using the Column Format options:


Use this to explicitly set the width of the column. Column widths can also be altered by dragging the right-hand column boundary in the heading as shown. A width setting of zero makes the column entirely invisible.

Tip: You can highlight an entire column by clicking in the heading of the column. If you then press your Keypad-enter key (or press Ctrl-M/⌘-M), the column settings will open. Highlighting a column and pressing Tab will highlight the next column (or shift-Tab for previous). If you tab into a column with zero width, no column will show as highlighted, but you can still open the settings by pressing Keypad-enter.


Use the alignment option to specify whether information in the column should appear against the left or right hand side of the column, centred in the column, or on the right side with the decimal points aligned.

You should always choose Decimal alignment for numeric data.

On some printers, you may need to switch off the Font Substitution option for the printer in order for figures to be correctly aligned.


Use the format option to specify the format in which numeric values should be printed. The pop-up menu provides examples of the format for positive and negative numbers. Zero balances always print with positive number formatting. Calculations resulting in zero print with the formatting for the sign of the result (which may be positive or -ve zero).

The format options are as follows (the two right hand columns are the format constant name and number, either of which can be used as parameters to functions such as TextToNum):

Positive asNegative asDescriptionNameNo.
Non-NumericUse this if the column is a calculation that returns a non-numeric result -
0-0integer, negative with minus signNumFormInt 0
0.00-0.002 decimal places, zero pad, negative with minus signNumFormDec 1
0(0)integer, negative with parenthesesNumFormIntParen 2
0.00(0.00)2 decimal places, zero pad, negative with parenthesesNumFormDecParen 3
0 DB0 CRinteger, positive with DB, negative with CRNumFormIntCRDB 4
0.00 DB0.00 CR2 decimal places, zero pad, +ve with DB, -ve with CZNumFormDecCRDB 5
00 CRinteger, negative with CRNumFormIntCR 6
0.000.00 CR2 decimal places, negative with CRNumFormDecCR 7
0.000-0.0003 decimal places, zero padNumForm3DP 8
0.########-0.########up to 8 places after the decimal placeNumFormMax8DP 9
0.##-0.##up to 2 places after the decimal placeNumFormMax2DP 10
0.####-0.####up to 4 places after the decimal placeNumFormMax4DP 11
0.00##-0.00##2 decimal places, with up to 2 more significant digitsNumFormMin2DP 12
0.0000-0.00004 decimal places, zero padNumForm4DP 13
0.0-0.01 decimal placeNumForm1DP 14
0.000000-0.0000006 decimal places, zero padNumForm6DP 15
(no sep)
(no sep)
up to 4 places after the decimal place, no thousands separatorNumFormNoThouSep 16
(no sep)
(no sep)
2 decimal places, no thousands separatorNumFormDecNoThouSep 17
0.0e0-0.0e0Scientific notationNumFormSci 18
0.0xxxxx-0.0xxxxxForces output through printf "%f" (also implies no decimal separator and nonlocalised decimal point)NumFormPrintf 19

The dollar and the percent check boxes can be used to include the currency and/or dollar symbol in the formatted number.

Zero is Blank

If this is set, zero values will show as blanks on the report.


Use these setting to indent the text output in the column by the number of points indicated. This is useful if you have right aligned and left aligned columns adjacent to each other. You can specify both a right and left inset.