#1
|
|||
|
|||
formating a percentage in a Mail Merge
I have an excel data source that is a percentage. I have the following formula {={MERGEFIELD INTEREST_RATE}*100\# 0%}. The outer {} were entered using control F9 and the MERGEFIELD was entered by selecting it from the dropdown under Insert Merge field.
When it is merged the output is { =0.055*100\# 0%}. Can anyone tell me what I have done wrong? |
#2
|
||||
|
||||
Hi dkalsow,
The only way I can see that happening is if you have ordinary braces inside the outer pair of field braces.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I am creating it this way <control> <f9>.
Typing = Insert Merge Field (Interest_Rate) Typing *100\#0% After the merge is get {=5.5*100\#0%} What am I missing? Thanks! Dale |
#4
|
||||
|
||||
Hi Dale,
Are you actually executing the merge, which outputs all the records at once, or just previewing one record at a time?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
percentage increase? | dgardner | Excel | 2 | 07-13-2011 03:04 PM |
percentage on columns | 911 | Excel | 1 | 09-01-2010 09:28 AM |
Merge Documents without loosing formating | dewilk | Word | 0 | 02-23-2010 02:57 PM |
Formating in Mail Merge | roshagc3 | Outlook | 0 | 12-15-2009 12:20 AM |