Melissa has attended:
Excel Advanced course
Excel Intermediate course
Excel Advanced course
Date formatting
My question for the team is... when I do a mailmerge from excel the dates are displayed as a number rather than a date, even though in excel my dates are stored as dates. Any ideas please?
RE: 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
RE: Date formatting
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
RE: Date formatting
Dear Marius
Thank you so much for the alternative solution, I've also tried this and it's a good alternative so will be using them both depending on what I'm doing,
Much appreciated, apologies for the delay in my response, I'm only just catching up after Covid finally caught up with me!
Best wishes
Melissa
