Mixed Cell Formatiing

G

Gene

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

Dave Peterson

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

Gene

Dave Peterson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Converting URLs in comments to Markdown-formatted links 2
Newbie Help - IF Yes No Function 0
MS Project. Real progress of the project, % complete 1
Excel does not accept text format! 0
VB Script reference cells for in current table? 1
Display weeks from a Milestone 0
Excel - Wich Function should I use? 1

Top