| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting Concatenated Cells
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 |
|
#2
|
|||
|
|||
|
Quote:
Thanks for looking Paul ="Average Salary - "&TEXT(SUBTOTAL(1,R4:R174),"£#,##0.00") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Concatenated Cells
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Concatenated Cells
=CONCATENATE("Average Salary - ",TEXT(SUBTOTAL(1,R4:R174),"£#,##0.00"))
-- David Biddulph "Paul S" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font formatting in a concatenated string | Excel Discussion (Misc queries) | |||
| concatenated lookup? | Excel Worksheet Functions | |||
| appearance of a concatenated value | Excel Worksheet Functions | |||
| warning with concatenated date | Excel Discussion (Misc queries) | |||
| concatenated text to formula | Excel Discussion (Misc queries) | |||
Linear Mode
