Mail Merge date showing as number in Word

I have an excel spreadsheet that I use to create my mail merge in word. My mail merge has been working fine until today. I have 3 merge fields that show dates and one of them is now only showing numbers, the other two are still formatted correctly. Nothing has changed in my spreadsheet but went ahead I cleared the date formatting and reformatted those columns to see if that was the problem but it is still not working.

Does anyone have any clue as to why this is happening?

That suggests the errant column has a mix of numbers/text and dates. You should only have one data type in a column.
Cheers
Paul Edstein
(Fmr MS MVP - Word)

10 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

There are only dates in this column.

8 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I suspect on close inspection you'll find some of those dates have been input as text, not as dates. Multiple empty cells at the top of the column may also cause the mailmerge to treat it as a text column.
Cheers
Paul Edstein
(Fmr MS MVP - Word)

24 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 30, 2024 Views 19,009 Applies to: