Thread: Change Format from Number to Percentage (sounds easy enough)
View Single Post
  #1   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)
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%)
Reply With QuoteReply With Quote