View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CFD CFD is offline
external usenet poster
 
Posts: 1
Default Mail Merging Dates from Excel - Word Simple Problem!


Simple issue. In Excel I have dates in the form 26 June 2006 and I wish
to mail merge them with iother data into a word file. However, when I
do this, the dates appear in the word file in American date format
06/26/2006 ... not 26 June 2006.

Strangely even if I put the date in the excel cell as 26/06/2006
(Australian date formatting), it still turns up in the word file as
06/26/2006!

Any ideas how to fix this annoying problem?


--
CFD


------------------------------------------------------------------------
CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=560905