Date formatting

Hi Melissa,

Thank you for the forum question.

If your dates are correct in Excel, it can be a problem with the merge code in MS Word.

Please have a look at the link below:

https://www.westernsydney.edu.au/tld/home/how_to/how-to_resources/microsoft_word/date_correction_in_word_mail_merge

Please let me know if this is not doing the job.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hello Melissa,

Jens has suggested an excellent solution. I can suggest a second solution, so you can choose the one that works best for you.

I add another column to my Excel database and then I convert the dates to text with the following function:

=TEXT(B2,"dd/mm/yyyy") (where B2 represents a date cell)

When I bring this column into the merge, it forces Word to display the dates as dates instead of numbers.

I hope this helps.

Kind regards
Marius Barnard
STL