Question Locked

Mail merge office 2007 dates

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I merge dates from an excel sheet the date comes in as a 5 digit number. I can't get the formatting to correct this. I've tried using the switches and it doesn't seem to work. I'm using office 2007. PLEASE HELP ME!!

3 replies

by highab

Hello I have the same problem, did you manage to work it out? How did you do it?

by thumbsup2

Excel stores the date internally as a 5 digit number representing how many days have passed since a certain date in the past (I forget what date that is). You can change how that date is formatted in Excel, but the formatting there doesn't change what is really stored internally.

To format a date in mail merge, you need to use the Date-Time Picture Switch. In Word, which is where the merge takes place, search Word Help for "Date-Time Picture Switch" or for "Format Merged Data".

For example, the switch \@ "dddd, MMMM d, yyyy" in the field { DATE \@ "dddd, MMMM d, yyyy" } displays "Friday, November 24, 2002." Combine the date and time instructions ? day (d), month (M), and year (y); hours (h) and minutes (m) ? to build a date-time picture. You can also include text, punctuation, and spaces.

This discussion is closed to new replies.