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