Formatting mail merge fields in Word

This comes up all the time at work, and I always struggle to find the page and never remember to bookmark it. So now I don’t need to! Who’d have thought you could use a blog as a bookmarking tool? Oh yeah, StumbleUpon realised.

Anyway.

The reason I needed it this time was because numbers in an Excel spreadsheet were being rounded up, or down, or converted from (say) “75.0” to “74.99999999999999” for seemingly no reason when mail merged in Word. The solution, as indirectly offered by the Meister Word FAQ (linked below), was to edit the mergefield codes:

This wasn’t working:

{ MERGEFIELD Score }

But this does:

{ MERGEFIELD Score \# “0.0” }

Hurrah!

Meister Word FAQ

Leave a Reply