Formatting dates when mailmerging

  Mobility 13:53 02 Feb 04
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 04

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now