Turn your field codes on: Press ALT + F9 to do this…
It goes from this appearance:
Before:
After:
Then your fields will not have the formatting that you see in my display you will need to add it.
You will add this code inside the merge field to format it to look like money:
# "$,0.00;($,0.00)"
For more information visit this article:
