Help needed with MERGECODE format returning a space

Question

Hi All,

I am having an issue with a template for Xero using Mergecodes in Word.

I have contacted Xero but they say they can't see any issue with the template itself and they suggest it code be an issue with Word.

I am using the following code  {MERGEFIELDTaxInclusiveUnitAmount#,##0.00;(#,## 0.00) }.

Somehow this returns a space in the amounts such as: 1,25 1.55 instead of 1,251.55 and (410 1.23) instead of (4101.23).

I can't see anything wrong with the format of the table either.

If anyone has a clue, I would be grateful.

Answer 1

Your MERGEFIELD should be coded as:

{MERGEFIELD TaxInclusiveUnitAmount # "#,##0.00;(#,##0.00)"}

For more mailmerge hints, see: Mailmerge Tips & Tricks