I'm trying to merge some currency field into a document.
In the document as it stands, the figures will show up correctly, i.e.
$14,112.30 for instance

but then I saved the word document under a different name and added the
same query as the data source but when I insert the mergefield i get
unformatted numbers i.e. 14112.30. The weird thing is when I reconnect
the query, it'll lose for formatting to.

I've looked in the help file of word
I've looked at the field codes for mergefield

and I can't see how the first document is formatting the number

Can anyone offer a suggestion on how I can retain the currency
formatting in the mergefield automatically?