formula in a cell that references a different cell (which is a percentage) but doesnt display it as a percentage...

[kbishop94]

this is probably a very simplistic question... but I still can't make my formula to properly display (and probably format) it so that it shows the value as a percentage and without rounding it any extra numbers like it does right now....

the formula in the cell is:

="ALL FACILITIES: " & IH242&"% attended"



where cell IH242 (green arrow in the screen shot above) contains the formula: =(IG241/IG242)*1
and is formatted like this:




my target cell (the one that contains the formula that starts with " = "ALL FACAILITIES: " ) currently displays like this:


and I want it to look like this:



Any help is greatly appreciated!

 

[6StringJazzer]

When you reference another cell when building text in a formula, Excel doesn't care about the format in the other cell. It just treats it as a number. So you have to explicitly format it in the formula.

Try this:

="ALL FACILITIES: " & TEXT(IH242, "0%") & " attended"

 

[kbishop94]

When you reference another cell when building text in a formula, Excel doesn't care about the format in the other cell. It just treats it as a number. So you have to explicitly format it in the formula.

Try this:

="ALL FACILITIES: " & TEXT(IH242, "0%") & " attended"

Awesome... and understood. Thank you, Jeff