Thread: [Solved] Mail Merge, Number to 2 Decimal Places
View Single Post
 
Old 07-20-2011, 02:03 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Luke,

Try a field coded as:
{QUOTE{SET Val {MERGEFIELD MyField \# 0.00}}{IF{REF Val}= {=Val \# 0} {=Val \# "£,0"} {IF{REF Val}= {=Val \# 0.0} {=Val \# £,0.0} {=Val \# £,0.00}}}}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote