(Tech Tip: Word) How to format numbers in a Word mail merge (sourcing Excel)

(Tech Tip: Word) How to format numbers in a Word mail merge (sourcing Excel)

Don’t struggle getting number formatting like $ signs, to show up correctly in a Word mail merge. This happens because Word looks at the underlying numeric value and ignores the cell formatting.

For what I consider the commonest of mail merge methods (Word sourcing Excel) , this is way harder than it should be.