Thread: [Solved] Merge Field Ignoring Zeros
View Single Post
 
Old 05-04-2012, 01:56 AM
Welshie82 Welshie82 is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Oct 2011
Location: Birmingham
Posts: 33
Welshie82 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Your field switch effectively says to only output non-zero decimals. If you use:
{MERGEFIELD amount \# ,0.00}
you will get all decimals to two places, and amounts of one thousand and over with thousand separators.
Wonderful, that worked! Thank you Macropod, as always.
Reply With Quote