Separators > format

Use the Separators Format property to specify the placement and value of the fraction separator.

To define the separator format, select one of the separator formats from the drop-down list in the Value column.

####[.##]
The fractional separator is present if there are fractional digits. There is no thousands separator.
####.##
The fractional separator is always present, even if there are no fractional digits. There is no thousands separator.
#[,]###[.##]
The fractional separator is present if there are fractional digits. There is an optional thousands separator.
#[,]###.##
The fractional separator is always present. There is an optional thousands separator.
#,###.##
The fractional separator is always present. There is always a thousands separator if there are more than three whole number digits.

Feedback