Currency Field - Displaying Incorrect Value when Formatted

[DarrenE]

I have a mail merge in word from access (all 2016).



Before I apply the formatting, the data is displayed correctly @ 23.5.

However, when I apply the formatting: \# £,#.00 ~ MERGEFIELD "MyField" \# £,#.00 it displayed the value £28.00.

Any ideas would be appreciated, as it's driving me mad! I have fiddled with variances on \# £,#.00...