I have set up a mail merge which pull figures from an Excel spreadsheet and
displays them in a Word document.

The figures inputted into the spreadsheet are to two decimal places, though
the cell formatting means that they are displayed as being to no decimal
places.

I want the same rounded figure to appear in my Word files, unfortunately the
mail merge is ignoring the formatting and displaying the two decimal place
figure. Is there anyway around this? I don't mind permanently losing the two
decimal places in Excel if this is neccessary.

Thanks!