Hi,
I am using this formula to list score and name in a single cell on a separate sheet.
=IF(AE4="","",AE4&" "&INDEX($B$4:$B$26,MATCH(COUNT(AE$4:AE4),$AC$4:$AC$26,0)))
This references in cell AE4 a score with two decimals. It will show the decimals except when the number has no decimals. I would like to show a number with a decimal, even if the number has no decimals. For example I want to show 12.0 (instead of 12) and then the name. I tried formatting the cell but since it is a mixed text/number cell that is not possible.
Any suggestions?
Thanks
Bookmarks