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!

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!

