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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment