Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as text in Mail merges
In Word:
Select the mergefield that contains your date Press Shift-F9 Modify it so it looks like this {MERGEFIELD OrderDate \@ "dddd, MMMM d, yyyy" } replacing OrderDate with the name of your date field. Formatting switches are explained in Word's Help file: Date-Time format switch The Date-Time format switch (\@) specifies the display of a date or time. For example, the switch \@ "dddd, MMMM d, yyyy" in the field { DATE \@ "dddd, MMMM d, yyyy" } displays "Friday, November 23, 2007." Combine the following date and time instructions €” day (d), month (M), and year (y); hours (h) and minutes (m) €” to build a date-time format. You can also include text, punctuation, and spaces. "Candida" wrote: Hi, I'm trying to do a mail merge between a Word Document and an Excel spreadsheet. I'm using the latest ('07) versions of both programs. I have several columns of dates in my data (such as original; billing date, due date, etc.) I have them formatted as dates in Excel. My problem is that when I do the merge, Word reads them as numbers such as 38982 or the like. I have tried converting the date columns to text in Excel, but then ALL the dates look like their serial numbers. How can I get around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merges on Excel | Excel Discussion (Misc queries) | |||
Importing dates and military time from Excel into word doc mail me | Excel Discussion (Misc queries) | |||
E-mail notifications from Excel based on dates in speadsheets | Excel Worksheet Functions | |||
Dates keep changing to US format when mail merging | Excel Discussion (Misc queries) | |||
£1.30 merges from excel to word as £1.3 (the end zero is lost) | Excel Discussion (Misc queries) |