Thread: [Solved] formating a percentage in a Mail Merge
View Single Post
 
Old 04-01-2012, 12:45 PM
dkalsow dkalsow is offline Windows Vista Office 2007
Novice
  
Join Date: Apr 2011
Posts: 6
dkalsow is on a distinguished road
Default 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?
Reply With Quote