Custom Numeric Formats

You can use one or more digit characters to create a simple custom numeric format. You can use the following digit characters:

• 0 (zero). Displays a corresponding digit in the output.

• (#) number sign. If the digit is significant, then it displays it in the output. A significant digit is a digit that resides in the middle of the number or is not zero.

The following table includes examples of using zero and the number (#) sign.

Number	Format	Result
1234.56	#	1235
1234.56	#.##	1234.56
1234.56	#.#	1234.6
1234.56	######.##	1234.56
1234.56	00000.000	01234.560
0.12345	#.##	.12
0.12345	0.##	0.12

You can use a decimal separator as an option.

A comma instructs Siebel VB to place a comma between every three digits that occur to the left of the decimal separator.

The following table includes examples of using a comma.

Number	Format	Result
1234567.8901	#,#.##	1,234,567.89
1234567.8901	#,#.####	1,234,567.8901

Siebel VB uses the current international settings for your computer to determine the character to display for a comma or a period. For example, some locales use a period as the decimal separator. Other locales use a comma.