Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I control the formatting of numbers, currency, and dates in DataPrompter fields?

0
Posted

Can I control the formatting of numbers, currency, and dates in DataPrompter fields?

0

Yes you can. DataPrompter doesn’t provide an interface for this, but it is easy enough to do, it has to be done only once, and you can do it as follows: 1. Open a document that contains some DataPrompter datafields. 2. Press Alt+F9 to view the field codes. NOTE: The field code for a typical datafield will look as follows: { DOCPROPERTY “z:|_test” \* MERGEFORMAT } 3. Insert into the field code the desired “Picture Format” for each field. For example, to display numeric values with two digits to the right of the decimal, you would insert the following Picture Format: { DOCPROPERTY “z:|_test” \# ###.00 \* MERGEFORMAT } NOTE: For more information about Picture Format switches, look up field switches in the Word help system, then select Date-Time Picture Field Switch or Numeric Picture Field Switch. 4. Press Alt+F9 to hide the field codes. 5. Press Ctrl+Alt+Shift+S to Show the DataPrompter dialog box. 6. Enter some values and click OK. NOTE: Later, if you insert additional copies of a field

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123