Formatting dates when mailmerging

  Mobility 13:53 02 Feb 2004
Locked

When mail merging in Word the date format as taken from an Excel file is wrong. A field in the Excel file is 23/1/2004 but appears in the Word document as 1/23/2004 - the usual U.S. format. Cahanging the Excel format to 23 January 2004 still gives the same fault. Any ideas?

  Sheila-214876 14:05 02 Feb 2004

Have you checked in Word. Go to Insert, Date and Time, Pick the format you want in the lefthand window. In the righthand window make sure language is English (UK).

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Ryzen news - release date, UK price, features and specifications

The pulp art of 80s computer game magazine covers

Best value Mac: Which is the best £1249 Mac to buy

Comment faire des captures d’écran sous Windows 10 ?