Forum Discussion
Cents Missing from Template Currency Fields
I am using Power Automate to populate a Word Invoice Template.
I need to be able to show the cents (including .00) in the subtotals
and total fields of the template.
Where (the Word Template or the Flow) and how do I make this
adjustment to show the cents in the currency fields?
1. Check field formatting: Right-click on the currency field and select “Toggle Field Code”.
Check if the field code contains formatting instructions (e.g. \#“$#,##0.00”).
If there is no formatting instruction, manually add \# “$#,##0.00” to ensure that the cents section is displayed.
2. Update Field: Select the currency field and press F9 to update the field.
If the field still does not display the cents portion, try reinserting the field.
3. Reinsert Currency Field: Delete the existing currency field.
Click Insert > Text > Document Parts > Fields.
Select the Currency field and set the format to \#“$#,##0.00”.
4. Check Template Settings: Open the template file and check to see if any of the global formatting settings affect the Currency field.
Modify the default formatting in the template to ensure that the currency field displays the cents section.
5. Use a formula field: Use a formula field (e.g. =10.00 \#“$#,##0.00”) to ensure that the cent portion is displayed.
Right-click on the formula field and select “Toggle Field Code” to check the formatting.
6. Contact Microsoft Support: If none of the above methods work, it is recommended to contact Microsoft Support team with detailed error message and screenshots for further assistance.
