MergeFields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jo Davis - 18 Mar 2008 13:48 GMT

I have a letter which is merged from a spreadsheet. I have three merge
firelds which all look at the same cell in excel, however, on one of the
mergefields in the letter I want to add 0.01% to the value that it returns.
Is there anyway I can do this through the toggle field and update?

Below is the current data in the mergefield:

{MERGEFIELD "Spreadsheet"\#,##0.00}%

Reply to this Message

Doug Robbins - Word MVP - 18 Mar 2008 19:57 GMT

Use

{ = {MERGEFIELD "Spreadsheet"\#,##0.00} + .01 }%

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 have a letter which is merged from a spreadsheet. I have three merge
> firelds which all look at the same cell in excel, however, on one of the
[quoted text clipped - 5 lines]
>
> {MERGEFIELD "Spreadsheet"\#,##0.00}%

Reply to this Message

Rate this thread: