Add or remove a thousands separator in a number

Microsoft Office InfoPath

Show All Show All

Add or remove a thousands separator in a number

  1. In design mode, right-click the text box or expression box whose data you want to format, and then click Properties.
  2. On the Data tab or the General tab in the Properties dialog box, click Format.

    Note  You can add a thousands separator only for text boxes that have a decimal or whole number data type or for expression boxes that are formatted as a decimal or whole number.

  3. In the Format dialog box, do one of the following:
    • To add a thousands separator to the number, select the Use a digit grouping symbol check box.
    • To remove the thousands separator from the number, clear the Use a digit grouping symbol check box.

Notes

  • Depending on locale, the separator might separate more or less than thousands.
  • Adding or removing a thousands separator affects only the displayed value, not the value that is saved in the data source.