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.
How do I mix formats in one cell?
google spreadsheets;formatting
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.aspxWhat 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.