Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I've got a string like

 ="Daily Avg: " &AVERAGE(C3:C13)

I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts?

I've searched Google's help centre but found nothing.

share|improve this question
add comment

2 Answers

up vote 6 down vote accepted

The text() function might help you out. There is better documentation of it on the Excel help site: http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx

What you're looking for is wrapping your average() function in the text() function like this:

="Daily Avg: " &text(AVERAGE(C3:C13),"0.00")

text() works like this:

text(number,format) where number refers to the data you're trying to convert and format refers to the way you'd like numbers to be displayed. In my example I just carried out the decimal to 2 places.

share|improve this answer
add comment

The way you prepare the notation, makes me think of how I do it in MS Access.

In google spreadsheet you can also use the following straight forward formula:

=CONCAT("Daily Avg: ";FIXED(AVERAGE(C3:C13);2))
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.