how do I format the number in a formular that contain text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Excel 2000 and would like to format the number in the following
formular with zero decimal places. ="AVG" &" "&averagea(D5:AB5) which
returns 2787.375.
 
One way:

="AVG " & TEXT(AVERAGEA(D5:AB5),"0")

or

="AVG " & ROUND(AVERAGEA(D5:AB5),0)
 
Back
Top