Mixed Cell Formatiing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gene - 22 Jul 2006 18:29 GMT

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.

Reply to this Message

Dave Peterson - 22 Jul 2006 20:09 GMT

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.

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

Signature

Dave Peterson

Reply to this Message

Gene - 26 Jul 2006 02:37 GMT

> You could modify your formula:
>
[quoted text clipped - 11 lines]
> > would be: "Avg.: " (the result from a formula calculation). How can I do
> > this? Thanks.

Reply to this Message

Gord Dibben - 22 Jul 2006 20:14 GMT

Gene

="Avg: " & AVERAGE(A1:A10)

Gord Dibben MS Excel MVP

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

Reply to this Message

Gene - 26 Jul 2006 02:38 GMT

> Gene
>
[quoted text clipped - 6 lines]
> >would be: "Avg.: " (the result from a formula calculation). How can I do
> >this? Thanks.

Reply to this Message

Gord Dibben - 26 Jul 2006 04:41 GMT

Thanks for the feedback Gene.

Gord

>> Gene
>>
[quoted text clipped - 6 lines]
>> >would be: "Avg.: " (the result from a formula calculation). How can I do
>> >this? Thanks.

Gord Dibben MS Excel MVP

Reply to this Message