How do I format a number?
Connect will use the default format to print the values in a column. You can replace the default format with the format that best suits the purpose of the report.
You can format a
-
Standard number. This is any number.
-
Currency. This is a number that displays a monetary amount.
-
Percentage. This is a number that displays a percentage.
-
Special. This includes numbers that are not covered by the standard, currency, and percentage categories. For example, a bank account number, Social Security number, Tax ID, or a Zip Code.
-
Custom. This is for columns that may display more than one number or may require a variation of a number format.
Formatting a number
1. Open a report.
2. Click to select the Columns tab.
3. Use the Section menu to select the report section that will contain the new report line.
4. Click to select a column that displays a number.
The column properties display on the Column subtab.
5. Find the section titled Format.
6. Click to select the option titled Custom.
7. Click to select the button at the end of the Custom field.
The Number Format form displays.
8. Click to select a number format from the list.
9. Click OK.
Connect will use the selected format to display the numbers in the column.
Copyright © 2025 Caselle, Incorporated. All rights reserved.
Related Articles
How do I define a customer number format?
Set up the mask for the customer number format. The Customer Number Format is a combination of symbols that tells the system how to format the customer number. Example: If the default format is #.####.#, and then the Customer Number Format allows a ...How do I format a rate number?
Assign a rate number. Usually, a rate is created for a specific service and the service number is assigned as the first digit of the rate number. Search window, rate number Example: 101, where 1 is the service number and 01 is the rate number for the ...How do I format an account number mask?
Use these instructions to set up Connect to run without the Caselle General Ledger. A mask is series of characters that tells the system how to format a number. This is a set of commonly used masks: Balance sheet mask: FF-AAAA Revenue mask: FF-SS-RRR ...How do I format text?
Connect will use the default format to print the values in a column. You can replace the default format with the format that best suits the purpose of the report. Formatting text in a column 1. Open a report. 2. Click to select the Columns tab. 3. ...How do I mask the Social Security number (SSN) on reports?
Replace the Social Security number (SSN) that prints on the report with a mask that only shows the last four-digits. When the Social Security number is not masked, the report prints: 555-55-5555 When the Social Security number is masked, the report ...