View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger Aldridge Roger Aldridge is offline
external usenet poster
 
Posts: 1
Default How stop Excel file UK date order changing to US order in m.merge

I have DOB field in an Excel file in deliberate UK order (eg. 23/05/2000)
which I want to put onto labels. I go through the mail merge wizard but when
i call up the file and look at it, the DOB has changed to US order (eg.
05/23/2000) and this then appears on the labels.
Using 2003 Office.