| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula, text and currency in same cell
Does anyone know how do combine a formula, text and currency in the
same cell? I'm trying to get a cell that displays like this: Average monthly income is: £1,000 by combining 3 things: Text ("Average monthly income is: ") Formula (=A1/12, where A1 is total annual income) Currency (figure displayed with £ and comma separator) Any help would be great. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula, text and currency in same cell
Maybe
="Average monthly income is: " & TEXT(A1/12,"£0,000") Mike " wrote: Does anyone know how do combine a formula, text and currency in the same cell? I'm trying to get a cell that displays like this: Average monthly income is: £1,000 by combining 3 things: Text ("Average monthly income is: ") Formula (=A1/12, where A1 is total annual income) Currency (figure displayed with £ and comma separator) Any help would be great. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula, text and currency in same cell
one way is
="Average monthly income is: "&TEXT(A1/12,"[$£-809]#,##0") -- regards, " wrote: Does anyone know how do combine a formula, text and currency in the same cell? I'm trying to get a cell that displays like this: Average monthly income is: £1,000 by combining 3 things: Text ("Average monthly income is: ") Formula (=A1/12, where A1 is total annual income) Currency (figure displayed with £ and comma separator) Any help would be great. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get currency format from souce cell(s) of a formula or referance | Excel Discussion (Misc queries) | |||
| Changing cell format from text to currency | Excel Worksheet Functions | |||
| Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
| changing cell values with text and currency | Excel Discussion (Misc queries) | |||
| Currency to Text | Excel Worksheet Functions | |||
Linear Mode
