| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Mixed Cell Formatiing
You could modify your formula:
="Avg: " & average(a1:a10) Or you could use a custom format (format|cells|number tab) like: "Avg: "#,##0.00 In the first example, the cell is no longer a number--it's text. In the second example, the cell is still a number--it's just formatted nicely. Gene wrote: I would like to have a mixed cell format in a single cell, i.e., a label followed by the results of a formula calculated in the cell. An example would be: "Avg.: " (the result from a formula calculation). How can I do this? Thanks. -- Dave Peterson |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Thanks Dave Peterson for your prompt and helpful response.
"Dave Peterson" wrote: You could modify your formula: ="Avg: " & average(a1:a10) Or you could use a custom format (format|cells|number tab) like: "Avg: "#,##0.00 In the first example, the cell is no longer a number--it's text. In the second example, the cell is still a number--it's just formatted nicely. Gene wrote: I would like to have a mixed cell format in a single cell, i.e., a label followed by the results of a formula calculated in the cell. An example would be: "Avg.: " (the result from a formula calculation). How can I do this? Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Mixed Cell | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Hybrid Mode
