Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as text in Mail merges
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 | |||
Dates as text in Mail merges | Excel Discussion (Misc queries) | |||
Mail Merges on Excel | 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) |