Formatting Concatenated Cells

[Paul S]

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

 

[Guest]

Try

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

Mike

 

[David Biddulph]

=CONCATENATE("Average Salary - ",TEXT(SUBTOTAL(1,R4:R174),"£#,##0.00"))