View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Candida Candida is offline
external usenet poster
 
Posts: 27
Default 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?