[Doug Robbins - Word MVP]

Try setting the "Confirm file coversions at open" item under
ToolsOptionsGeneral and then when you attach the data source, use the DDE
option.

You may also need to format the cells in column that contains that data as
Text.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"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.