How to limit an expression num output to two decimals 1

[eo]

Hi

I have the following expression

="Average Brokerage " & Avg(Fields!Brokerage.Value)

But it returns (for example) "Average Brokerage 13.58745625" where as I only want it to return "Average Brokerage 13.59"

How can this be done?

EO
Hertfordshire, England

 

[xlbo]

="Average Brokerage " & Format(Avg(Fields!Brokerage.Value),"0.00")

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question