Using financials in Mail Merges

Imagine you have a financial figure that you want to use in a mail merge (a salary, bonus, house prices etc.)

If you use them as they stand, they'll likely look rubbish. They won't show the currency and there won't be a lovely comma separating the thousands from the sub-thousands. Instead, create a new field containing the following formula (assuming the financial field you want to use is in B2):


Let's say the salary was £32,500. The ROUNDDOWN function will divide your salary by 1,000 and give you that figure—in this case 32. The MOD function also divides your salary by 1,000 but instead gives you the remainder—in this case 500. The & function is a shortcut for the CONCATENATE function, stringing multiple entries together. So it adds the £ at the beginning and the comma midway.

The formula would need some additional logic if the numbers were to stretch into the millions, but you get the picture.

This entry was posted in How to and tagged , , , . Bookmark the permalink.

2 Responses to Using financials in Mail Merges

  1. Handy, I wouldn't have thought to do it this way as I'd have used the field codes in word to format it there. It's always good to see some of the multiple ways you can get the same or similar result in Microsoft!

Leave a Reply

Your email address will not be published. Required fields are marked *