Currency switch

T

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
 
M

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
.
Click to expand...
Try \#£#,#.00
 
M

mr wizerd

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

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