Hello,



I am having an issue where a date is pulling through to a mail merge as a number, despite the correct toggle switch being used.

The switch being used is: { MERGEFILED SLA_Expiry \@ "d MMMM yyyy"}

But the result is: 45615

Could it be that the date is being pulled from a formula in the data source?

=IF(OR(ISBLANK(B3), ISBLANK(C3)), "", EDATE(B3, C3)-1)

If so, can this be fixed? I've never seen this before, it's always just worked. I've tried amending cell formatting and no luck

Thanks

Edit: This only happens when the data source is open

See Mailmerge Data Format Problems in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]