Formatting Concatenated Cells

P

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
 
D

David Biddulph

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