Hi again,
In my mail merge document I have 3 fields identically formatted (I think) for currency indicating cent values (Code below). However the 1st field does not show the cents. I tried editing with various spaces etc. saved and closed end reopened but no success
Note I copied the code without the brackets (and added them here myself) as this was the only way I could cut and paste the code.

Any advice.



Thanks in advance

If all three fields have identical formatting switches, all three should generate the same output format. That said:
• problems of this kind often arise where the field in the data source contains mixed data types (e.g. text, plus numbers or dates). You can coerce such fields to perform numerically using the technique described under Force '0' Substitution for Empty/Missing Records in the Mailmerge Tips and Tricks Sticky thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html)
• there should be spaces around the numeric picture switches (e.g. { MERGEFIELD "Collection_Total" \# €,0.00 })

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks, I'll recheck everything later as I'm at a different computer. My next move is to create a whole new document. I'll report back.