[macropod[_2_]]

Hi Mike,

The fact that there are different kinds of data in the fields doesn't prevent formatting switches being used. At most you'll need an
IF test. For example:
{IF{MERGEFIELD Data \@ "dd-MM-yy"}= "??-??-??" {MERGEFIELD Data \@ "dd-MM-yy"} {MERGEFIELD Data \# ",0.00"}}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


"Mike" wrote in message ...
How do I keep the display result in Mail Merge to follow exactly the format
set in the Excel file?

I cannot use the format switches due to the same field in the excel file
contains multiple format, ie. the same field contains data like date and
numbers, i need the display result in Word to show both dates and numbers.