I can find hundreds of posts about how to suppress zero values when doing a mail merge, however I want to do the exact opposite, I want zero values to display as £0.00.



How can I achieve that. My 'formula' is:

{ MERGEFIELD Amount \# £,#.00 }

The problem I have is that using this, any 0.00 amounts display as £ .00. I've tried formatting my source data as 'text', but that makes no difference, so I assume I need to tweak the formula in some way?

Many thanks

Okay, just answered my own question!

\# £#,##0.00

Perhaps better still is:
\# £,0.00
Using '\# £#,##0.00' forces Word to insert spaces before values less than £1,000.00.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]