#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jo Davis Jo Davis is offline
external usenet poster
 
Posts: 3
Default MergeFields

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}%
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default MergeFields

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

"Jo Davis" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Mergefields for RTF Document. vijay Microsoft Word Help 1 September 19th 06 12:26 PM
Mergefields Island Girl New Users 1 September 4th 06 01:41 AM
MERGEFIELDS Nathan Franklin Mailmerge 9 February 27th 06 12:57 AM
Moving mergefields ... Ger Mailmerge 1 July 21st 05 06:47 PM
Working with Mergefields Duncan McDonald New Users 1 November 25th 04 02:25 PM


All times are GMT +1. The time now is 03:53 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"