Display Negative Value as Positive

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martha - 17 Nov 2007 19:50 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 17 Nov 2007 20:01 GMT

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.

Signature

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

> 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
[quoted text clipped - 8 lines]
>
> Martha

Reply to this Message

macropod - 17 Nov 2007 20:17 GMT

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

Signature

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
[quoted text clipped - 5 lines]
>
> Martha

Reply to this Message

Martha - 17 Nov 2007 20:40 GMT

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

> Hi Martha
>
[quoted text clipped - 18 lines]
> >
> > Martha

Reply to this Message