# Showing decimals in combination text cell

1. ## Showing decimals in combination text cell

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  Register To Reply

2. ## Re: Showing decimals in combination text cell

TEXT(AE4,"0.0")
Does that work for you?  Register To Reply

3. ## Re: Showing decimals in combination text cell

Yes, that works!

Thanks!

=TEXT(AE4="0.00")&" "&INDEX(\$B\$4:\$B\$26,MATCH(COUNT(AE\$4:AE4),\$AC\$4:\$AC\$26,0)))

How would I keep the IF(AE4="","",AE4 component in the entire formual?

Thanks  Register To Reply

4. ## Re: Showing decimals in combination text cell

Try

=IF(AE4="","",TEXT(AE4,"0.00 ")&INDEX(\$B\$4:\$B\$26,MATCH(COUNT(AE\$4:AE4),\$AC\$4:\$AC\$26,0)))

or you could also use FIXED function to specifiy the number of decimals, it defaults to 2 if you don't explicitly state, i.e.

=IF(AE4="","",FIXED(AE4)&" "&INDEX(\$B\$4:\$B\$26,MATCH(COUNT(AE\$4:AE4),\$AC\$4:\$AC\$26,0)))  Register To Reply

5. ## Re: Showing decimals in combination text cell

Thanks a million. That works great!  Register To Reply