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.