Data frm excel to word using mail merge

[Param]

Hi,
I am using mail merge to create report. I encounter problem when working
with and printing mail merge. I need solution for:
1) number from excel e.g 20, turn 20.0 in word.
2) percentage frm excel e.g 67%, turn 67.33456 in word.
3) date from excel 30 March 2006, turn 30/3/2006 12:00pm

pls let me. Tq param

 

[Peter Jamieson]

Look up Word Help for field switches, e.g. so instead of

{ MERGEFIELD mydate }

you use

{ MERGEFIELD mydate \@"DD MMMM YYYY" }

Alternatively, revert to the old method (DDE) of link to Excel - check Word
Tools|Options|General|"Confirm conversions at open", go through the process
of connecting to your sheet again, and choose the DDE option when prompted.
This method is "deprecated", requires Excel on your system, and only works
with the sheet that excel opens by default - typically the first sheet in
the workbook.

Peter Jamieson