Display Negative Value as Positive

[Martha]

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

 

[Doug Robbins - Word MVP]

Use { = - { MERGEFIELD CURRENT _ } \# "$,0.00" }

You must use Ctrl+F9 to insert the field delimiters { }. You cannot enter
them using the keys on the keyboard that bear those symbols.

You use Alt+ F9 to toggle off the display of the field codes.

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

 

[macropod]

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

 

[Martha]

Thank you! I've got it.....

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

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