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