Using Thousands Separators

You can specify to use thousands separators in the Number field and the Calculated field.
When records are created, entered values and result values are displayed using thousands separators.

  • Thousands separators are not displayed when entering records.
  • Commas are used only for display purpose, and are not used as characters in fields. Therefore, you can use fields, where thousands separators are set, in formulas for other fields as well.


* If you use the YEN function in the Text field, values are displayed in "Yen" using thousands separators. Use the YEN function when the calculated result is string type.

Setting the Number Field

Select Use thousands separators. Thousands separators are displayed in the numbers you entered.

Setting the Calculated Field

Select Number with thousands separator (1,000). Thousands separators are displayed in the calculated results.