Currency switch

[Tubthumper]

Have looked through (and tried the suggestions) from the
previous postings on this subject, but still not working!!

Merging data from Excel to Word (2003), and 60 pence is
shown as 0.6 - which I'd like formatted to £0.60. Have
tried including the switch {MERGEFIELD "STgeranium"
\#"£#,##0.00" } but nothing happens!

Any help?

Thanks

 

[mr wizerd]

-----Original Message-----
Have looked through (and tried the suggestions) from the
previous postings on this subject, but still not working!!

Merging data from Excel to Word (2003), and 60 pence is
shown as 0.6 - which I'd like formatted to £0.60. Have
tried including the switch {MERGEFIELD "STgeranium"
\#"£#,##0.00" } but nothing happens!

Any help?

Thanks
.

Try \#£#,#.00

 

[mr wizerd]

Oops, I missed a zero - \#£#,#0.00

I had to play with it till I got it right.

 

[Guest]

Nice one Mr W!!

Thanks
Tubthumper