| 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. |
| 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 | |||
Threaded Mode
