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 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 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 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 add an electronic reading format?
Some meters can transmit meter readings from a meter at a service location to the meter reader. If your organization is using electronic meter reading, you will need to set up an electronic reading format to format the the meter reading file from the ...