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
|