Absolute Number Mail-Merge Switch - Software Download: Addin - hzfn.com

Software Download: Addin::
Fax4Word is a powerful Fax/Mail merge software that works as an MS Word . Change formula references from absolute to relative or relative to absolute.
http://www.sharewareconnection.com/titles/addin.htmHOME

Institute of Cost & Management Accountants of Pakistan Computer ::
File Format: PDF/Adobe Acrobat - View as HTMLAbsolute, relative addressing, cell labeling. Formulas, copying formulas. Mail merge using data from spreadsheets and/or tables.
http://www.icmap.com.pk/612.pdfHOME

The problem is, the number can be a positive or minus (and I've written an IF statement in Word to set wording accordingly), but I always want to display the number as a positive.

Currently -50 would appear as �-50.00, yet I would like it to appear as �50.00.

I can solve this by creating a new column in the spreadsheet and using the =ABS() function and then mail-merging both fields. This works, however, I'd rather keep the spreadsheet as simple as possible and use a switch or something in Word if possible...

Is there a method to do this? :)

Hi,

I'm mail-merging a field from a spreadsheet into Word like so:

{ MERGEFIELD "Pay" #�0.00 }

The problem is, the number can be a positive or minus (and I've written an IF statement in Word to set wording accordingly), but I always want to display the number as a positive.

"David Glassey" "add _option_ to build windows version as unicode ::
"Fixes for scrolling to reduce the number of doubles. . "ots REplaced magic numbers with:" "ots some work I did in my architecture class" "ots/ src/
http://www.abisource.com/mailinglists/abiword-dev/2003/Dec/att-0288/01-change-log-2-1-0.txtHOME

Currently -50 would appear as �-50.00, yet I would like it to appear as �50.00.

I can solve this by creating a new column in the spreadsheet and using the =ABS() function and then mail-merging both fields. This works, however, I'd rather keep the spreadsheet as simple as possible and use a switch or something in Word if possible...

Is there a method to do this? :)

You might find this reference helpful:
http://www.gmayor.com/negative_numbers_in_calculations.htm

Starkman

I found the solution today:

{ =ABS({ MERGEFIELD "Pay" }) #£0.00 }

:)

Thanks Starkman, I found that the ABS function in Word will work. :)

{ =ABS({ MERGEFIELD "Pay" }) }

Trouble is the #£0.00 switch doesn't seem to work with this function, but I'll keep experimenting... unless someone knows the solution to this too? :)

I found the solution today:

{ =ABS({ MERGEFIELD "Pay" }) #�0.00 }

:)

Say, I'm having a problem here trying to figure out what exactly solved the problem that was different than your post before the post with the solution. In both posts, you have the same information: the merge field info and the switch. Is it just that you figured out the spacing or something?

You know, I love working with formulas in Excel, but I hate them in Word. But . . . since this is a Word forum, I didn't say that!

Thanks,

Starkman