How do I format a merge field as Currency or %?

H

hmj3b5

I've tried the field codes and haven't gotten it to work how I want. My data
is formated in Excel as currency & percent but when I merge it into my letter
it comes out as a general number.
 
Top