Hi.

I have created a workbook for band competitions and one of the sheets is for the the awards announcer. This sheet lists the scores and schools. The score and schools are combined in one cell. I have formatted all cells from where the scores are copied to the Awards sheet to show 2 decimals but the formula resulting in a score and school shows 5 decimals. I know that I can use "set precision as displayed", but I am hesitant to do so. Is there a way to show two decimals in a mixed number/text cell?

Below is the formula to arrive at the score/school:

=MAX(IF(BH4:BH81<>"Exh",BE4:BE81))&" "&INDEX(B4:B81,MATCH(1,((BH4:BH81<>"Exh")*(BE4:BE81=MAX(IF(BH4:BH81<>"Exh",BE4:BE81)))),0))
This is an array formlula.

This results in 91.11875 School 8 - I would like it to be 91.12 school 8

Would it be possible to use a macro to specifically change this to two decimals in these cells? There are four cells where this needs to occur T82, AL82, AZ82 and BE82

Thanks for any help!