View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike C Mike C is offline
external usenet poster
 
Posts: 25
Default 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%)