Whole number and fraction format strings
Whole# substring name
- Substring value
- Meaning
MinDigits(1) + "#" + Value(1) + "###" + MaxDigits(1)
MinDigits(1) + "#" + "[" + Value(1) + "]" + "###" + MaxDigits(1)
- Specifies the thousands separator and the range of whole number digits. If min-digits is not used, the default is zero. If max-digits is not used, the default is "S". If a ThousandsItem is specified, a Value must be present as the default for the syntax item.
Fraction substring name
- Substring value
- Meaning
"V" + ImpliedPlaces
- Specifies the decimal to be in an explicit place, and ImpliedPlaces determines where the intended decimal separator is to be placed.
Value + MinDigits(1) + "##" + MaxDigits(1)
- Specifies the value of the decimal separator to be required and the range of fraction digits. If min-digits is not used, default is zero. If max-digits is not used, default is "S"
"[" + Value + MinDigits(1) + "##" + MaxDigits(1) + "]"
- Specifies the value of the decimal separator to be optional if there is no fractional portion of the number. It also specifies the range of fraction digits. If min-digits is not used, default is zero. If max-digits is not used, default is "S"