Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 8 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

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

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

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

So, if you want to add a string with a variable or function then more string, here is the format:

="Text " &DATEDIF(DATE(2015,9,8), TODAY(), "D" )  &" text."

Notice that adding more components requires the &.

share|improve this answer

Your Answer


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.