[Martha]

Thank you! I've got it.....
"macropod" wrote:

Hi Martha

You could use:
{=ABS({MERGEFIELD Current}) \# $,0.00}

But even simpler would be:
{MERGEFIELD Current \# $,0.00;$,0.00}

I note that the switch you're using is '$#,###.00 '. Do you realise this will pad out the field with spaces even when there are no
values? For example, 99 cents will be displayed as '$ .99'. At the very least, you might want '$#,##0.00 ', which would display
99 cents as '$ 0.99' and a nil value as '$ 0.00' instead of '$ .00'.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Martha" wrote in message ...
I'm trying to figure out how to bring a negative value over from Excel and
display as positive number in Word Mail Merge. I saw in one of the references
about formula ABS, but I get Syntax errors when I try to use it - I've tried
all possible spots - not clear where it goes in the following: {={MERGEFIELD
CURRENT_}\# $#,###.00 }.

thanks

Martha