November 25, 2010

Format date after merge

Problem: User wants european date format in Word after merging data date from an Excel document

Although regional settings are all set for local date format (date-month-year), after merge command, it appears in US format ie month - date - year.

Righ click Edit Fields
Field Codes
add this text to command already present:
\@ "d.M.YYYY"

If month appears as 00, original data for (stored in excel for example) date should be formated with *

DATUG is user defined field name.

Use ALT+F9 if data suddenly stops to merge, it is used to show format command from Field Codes.

No comments: