Change Format from Number to Percentage (sounds easy enough)
Thank worked, thanks very much.
"JE McGimpsey" wrote:
One way:
=SUM(U3:Z3) & TEXT(SUM(U3:Z3)/135," (0%)")
Nonte, however, that 72 is NOT 36% of 135, so I don't have any idea how
you got your original results...
In article ,
Mike C wrote:
I have a simple formula that I expanded on. The problem is that I want the
second part to show as a percentage and not a number. Any ideas or
suggestions on how to do this? Below is my formula.
=SUM(U3:Z3) & " (" & SUM(U3:Z3)/135 & ")"
Current Result: 72 (0.3613439612)
Desired Result: 72 (36%)
|