MergeFields

[Jo Davis]

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

 

[Doug Robbins - Word MVP]

Use

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

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