Minor typo  -# needed for numeric formats, e.g.

{ mergefield XLdata \#$,0.00 }

--
Peter Jamieson - Word MVP

if you open your mail merge main document and press Alt-F9, you should see
"mergefield fields" that look something like

{ MERGEFIELD myfield }

The { and } are special "field code braces" that you cannot insert or delete
using the normal {, } or delete keys. But the rest is just plain text and
you can type some extra stuff that tells Word how to format "myfield". For
example, you could tpype " "\#$,0.00" after "myfield" so you have

{ MERGEFIELD myfield \#"$,0.00" }

Then you can use Alt-F9 to see <<myfield>> again.

try it, see if it works,if not tel us what went wrong,

--
Peter Jamieson - Word MVP

When I merge the fields into Word, it changes the decimal places.  I need
the decimals to stay at 2 places as this number is to show currency.