Mixed Cell Formatiing Gene 22.07.2006 17:29:02 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.

Re: Mixed Cell Formatiing Dave Peterson <petersod[ at ]verizonXSPAM.net> 22.07.2006 19:09:28 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: [Quoted Text] > > 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

Re: Mixed Cell Formatiing Gord Dibben <gorddibbATshawDOTca> 22.07.2006 19:14:21 Gene ="Avg: " & AVERAGE(A1:A10) Gord Dibben MS Excel MVP On Sat, 22 Jul 2006 10:29:02 -0700, Gene <Gene[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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.

Thanks Dave Peterson for your prompt and helpful response. Gene 26.07.2006 01:37:02 "Dave Peterson" wrote: [Quoted Text] > 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 >

Thanks Gord Dibben for your prompt and helpful response. Gene 26.07.2006 01:38:01 "Gord Dibben" wrote: [Quoted Text] > Gene > > ="Avg: " & AVERAGE(A1:A10) > > > Gord Dibben MS Excel MVP > > On Sat, 22 Jul 2006 10:29:02 -0700, Gene <Gene[ at ]discussions.microsoft.com> 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. > >

Re: Thanks Gord Dibben for your prompt and helpful response. Gord Dibben <gorddibbATshawDOTca> 26.07.2006 03:41:05 Thanks for the feedback Gene. Gord On Tue, 25 Jul 2006 18:38:01 -0700, Gene <Gene[ at ]discussions.microsoft.com> wrote: [Quoted Text] > > >"Gord Dibben" wrote: > >> Gene >> >> ="Avg: " & AVERAGE(A1:A10) >> >> >> Gord Dibben MS Excel MVP >> >> On Sat, 22 Jul 2006 10:29:02 -0700, Gene <Gene[ at ]discussions.microsoft.com> 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