Try

=CONCATENATE("Average Salary -","£",ROUND(SUBTOTAL(1,R4:R174),2))

Mike



"Paul S" wrote:


I am using excel 2000

I have the followinng formula which calculates Average salary,

=CONCATENATE("Average Salary -"," ",SUBTOTAL(1,R4:R174)), I am using
this formula so that I can filter data and get the average for the
filtered data

this returns the value

Average Salary - 12129.5977192982

What do I need to do, to get it to return the value

Average Salary - £12129.60

Thx for any help

Paul




--
Paul S