View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Change Format from Number to Percentage (sounds easy enough)

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%)