Specify the number of decimal places displayed in a text box or expression box

In Microsoft Office InfoPath, you can add data formatting to text box, expression box, and date picker controls on your form template to specify how dates, times, and numbers are displayed when users enter them into forms that are based on your form template.

You can specify the number of decimal places that are displayed only for text box controls that have a decimal data type or for expression box controls that are formatted as a decimal. Changing the number of decimal places affects only the displayed value, and not the value that is saved in the data source.

  1. Double-click the text box control or expression box control whose data you want to format.

  2. In the Control Properties dialog box, do one of the following:

    • If you are using a text box control, click the Data tab.

    • If you are using an expression box control, click the General tab.

  3. Do one of the following:

    • For a text box, ensure that the Data type list displays the appropriate data type, and then click Format.

    • For an expression box, ensure that the Format as list displays the appropriate data type, and then click Format.

  4. In the Decimal places list, under Other options, do one of the following:

    • To display a fixed number of decimal places, select the number of decimal places that you want.

    • To show the number of decimal places that the user types into the control, click Auto.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×