| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Mixed Cell Formatiing
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. |
|
#2
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 |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Mixed Cell Formatiing
Gene
="Avg: " & AVERAGE(A1:A10) Gord Dibben MS Excel MVP On Sat, 22 Jul 2006 10:29:02 -0700, 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. |
|
#4
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 |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Thanks Gord Dibben for your prompt and helpful response.
"Gord Dibben" wrote: Gene ="Avg: " & AVERAGE(A1:A10) Gord Dibben MS Excel MVP On Sat, 22 Jul 2006 10:29:02 -0700, 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. |
|
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Thanks Gord Dibben for your prompt and helpful response.
Thanks for the feedback Gene.
Gord On Tue, 25 Jul 2006 18:38:01 -0700, Gene wrote: "Gord Dibben" wrote: Gene ="Avg: " & AVERAGE(A1:A10) Gord Dibben MS Excel MVP On Sat, 22 Jul 2006 10:29:02 -0700, 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. Gord Dibben MS Excel MVP |
| 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 | |||
Linear Mode
