Displaying currency in merge field?

[GregLB]

Hi

I am having trouble displaying a currency value on a report when inserting the result field as a merge field,

Relationships are OK!

In Projects Table, Quote Amount Field is displayed e.g. £3000.00

In Merge field on quote report it displays 3000 with no £ or decimal point when it is .00

Thanks

Greg

[comment]

See here and here.

[GregLB]

I just number formated the text box and it workad fine.

Many thanks!

Greg