Mail Merge Date Format Problem

[Nick]

Trying to merge in data from an Excel spreadsheet but when
the date goes in, it is in US format rather than english
format, i.e 08/31/04 rather than 31/08/04. Tried changing
the format in Excel first which doesn't work and my PC is
set up with UK date as standard.

Any ideas how I can change it?

Cheers
Nick

 

[Brian Kvalheim - [MSFT MVP]]

Hi Nick ([email protected]),
in the newsgroups
you posted:

|| Trying to merge in data from an Excel spreadsheet but when
|| the date goes in, it is in US format rather than english
|| format, i.e 08/31/04 rather than 31/08/04. Tried changing
|| the format in Excel first which doesn't work and my PC is
|| set up with UK date as standard.
||
|| Any ideas how I can change it?

Change the format to Text.
--
Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com
~pay it forward~

This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[Guest]

Perfect! Thanks very much.

Nick