[Doug Robbins - Word MVP]

The formatting switch should be

\# $,0.00

NOT

\# $0,00

In addition to the space between the \ and #, you have the comma in the
wrong place and you do not have the period.

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

"Kate" wrote in message
...
I am trying to do the same formating to allow my field to show as currency
and entered the following (fiels is called CURBL)

{MERGEFIELD CURBL \ # $0,00}

When I merge it still shows as 30 instead of $30.00.



"macropod" wrote:

You can do that by adding a numeric picture switch to the mergefield. To
achieve a two-decimal currency result:
.. select the Word MERGEFIELD and press Shift-F9. You should see
something
like-
{MERGEFIELD MyData}
.. edit the Word MERGEFIELD to look like-
{MERGEFIELD MyData \# $,0.00} or {MERGEFIELD MyData \# £,0.00}, etc,
depending on the required currency format;
.. press F9;
.. run your mailmerge.

See Word's help file for more information on field formatting


Cheers


"registrarirene" wrote in
message
...
When mail merging from an excel file to a word document, how do I keep
the
number or currency format? It keeps merging as a number of varying
decimal
points although it's formatting correctly in excel..