Properties and Formulas for Formatting Number Values

This report shows the various properties and formulas which can be used for formatting number values. Custom formatting is possible instead of using the system default format.

Such a background indicates that the field formatting is done by a formula.

Rounding

12,345.6800

12,345.6789

The blue number should be rounded to 4th decimal place

12,346.0000

12,345.6800

The blue number should be rounded to.zero decimal places.

12,000.0000

12,345.6800

The blue number should be rounded to thousands.

12,345.6789

12,345.6800

The blue number should be rounded to 4th decimal place as the property formula for "
rounding
" returns
4
.

12,346.0000

12,345.6800

The blue number should be rounded to zero decimal places as the property formula for "
rounding
" returns
0
.

12,000.0000

12,345.6800

The blue number should be rounded to thousands as the property formula for "
rounding
" returns
-4
.

N decimal places

12,345.68

12,346

The blue number should have zero decimal places.

12,346.0

12,345.68

The blue number should have one decimal place.

12,346.00

12,345.68

The blue number should have two decimal places.

12,346.000

12,345.68

The blue number should have three decimal places.

12,345.68

12,346

The blue number should have zero decimal places as the property formula for
"n decimal places"
returns
0
.

12,346.0

12,345.68

The blue number should have one decimal place as the property formula for
"n decimal places"
returns
1
.

12,346.00

12,345.68

The blue number should have two decimal places as the property formula for
"n decimal places"
returns
2
.

12,346.000

12,345.68

The blue number should have three decimal places as the property formula for
"n decimal places"
returns
3
.

The blue number should have the same value like the black one and the minus sign should be visible as prefix.

-12,345.68

12,345.68-

The blue number should have the same value like the black one and the minus sign should be visible as suffix.

-12,345.68

(12,345.68)

The blue number should have the same value like the black one and there should be simple brackets around the number.

-12,345.68

12,345.68

The blue number should have the same value like the black one and the minus sign should not be visible.

-12,345.68

-12,345.68

The blue number should have the same value like the black one and the minus sign should be visible as prefix as the property formula for negatives returns
leadingminus
.

-12,345.68

12,345.68-

The blue number should have the same value like the black one and the minus sign should be visible as suffix as the property formula for negatives returns
trailingminus
..

-12,345.68

(12,345.68)

The blue number should have the same value like the black one and there should be simple brackets around the number as the property formula for negatives returns
bracketednegatives
.

-12,345.68

12,345.68

The blue number should have the same value like the black one and the minus sign should not be visible as the property formula for negatives returns
nonegativesign
.

-12,345.68

-12,345.68

The blue number should have the same value like the black one and the minus sign should be visible as prefix as the property formula for negatives returns
crleadingminus
.

-12,345.68

12,345.68-

The blue number should have the same value like the black one and the minus sign should be visible as suffix as the property formula for negatives returns
crtrailingminus
.

-12,345.68

(12,345.68)

The blue number should have the same value like the black one and there should be simple brackets around the number as the property formula for negatives returns
crbracketednegatives
.

-12,345.68

12,345.68

The blue number should have the same value like the black one and the minus sign should not be visible as the property formula for negatives returns
crnonegativesign
.