Currency switch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tubthumper - 04 Dec 2003 10:05 GMT

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

Reply to this Message

mr wizerd - 04 Dec 2003 21:22 GMT

>-----Original Message-----
>Have looked through (and tried the suggestions) from the
[quoted text clipped - 9 lines]
>Thanks
>.

Try \#£#,#.00

Reply to this Message

mr wizerd - 04 Dec 2003 21:30 GMT

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

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

Reply to this Message

- 05 Dec 2003 10:18 GMT

Nice one Mr W!!

Thanks
Tubthumper

>-----Original Message-----
>Oops, I missed a zero - \#£#,#0.00
>
>I had to play with it till I got it right.
>.

Reply to this Message