View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lighthouse
 
Posts: n/a
Default Cell formatting in Mail Merge

I have an Excel spreadsheet, showing dates when a succession of different
stages are reached for each client in my conveyancing job. All dates are in
UK format in Excel. However, when I mail merge in Word using this data
source, all dates appear in Word as US format, and any empty cells are
populated with 12:00AM.

Could you please tell me if this is an Excel problem, and what the solution
may be.