Prevent Zero Values being Suppressed in a Mail Merge

[HangMan]

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

[HangMan]

Okay, just answered my own question!

\# £#,##0.00

[macropod]

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