Add or remove a thousands separator in a number

Microsoft Office InfoPath 2003

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 Control Properties.
  2. On the Data tab or the General tab in the Control 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 under Other options.
    • To remove a thousands separator from the number, clear the Use a digit grouping symbol check box under Other options.

Notes

  • Depending on locale, the separator may 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.