|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 22nd, 2006, 06:29 PM
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
July 22nd, 2006, 08:09 PM
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
July 22nd, 2006, 08:14 PM
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
July 26th, 2006, 02:37 AM
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
July 26th, 2006, 02:38 AM
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
July 26th, 2006, 04:41 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| insert date | Larry | Worksheet Functions | 28 | July 15th, 2006 02:41 AM |
| Compiling macro based on cell values | simonsmith | General Discussion | 1 | May 16th, 2006 08:31 PM |
| Conditional formatiing based on another cell | Number_8 | General Discussion | 3 | March 13th, 2006 12:35 PM |
| GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
| Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
Linear Mode
