Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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 add currency symbols only for text box controls that have a decimal or whole number data type, or for expression box controls that are formatted as a decimal or whole number. Adding or removing a currency symbol affects only the displayed value, 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 Data Type Format dialog box, do one of the following:

    • To add a currency symbol, click Currency, and then in the Currency list, select the type of currency that you want to display.

    • To remove a currency symbol, click Number.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!