Text in formula answer2

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Thanks Guys for all your help. I chose to use the formula
="Average age "&AVERAGE(F2:F353), since the other
suggested way of changing the cell format to custom
sometimes came up as ####. However, When I use the above
formula it changes the answer to 46.4567854, whereas
before it only had 2 decimal places. The cell format is
set on "number" with 2 decimal places, so I'm not sure why
this is happening.
 
Hi Rebecca
(Please stay with the same thread)

1) Use ="total "&TEXT(SUM(A1:A4),"0.00")
or
2) Use the custom format and widen the column if you see ####. One way to
widen the column to exactly the right amount is double click on its right
border (i.e. the line between B and C in the column heading)
 
Back
Top