View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default how do you do an average for percent without putting in the pe

heine7515 wrote:
I just multiplied my formula by 100 and changed my formatting to read
number instead of percentage as you said. I thought maybe there was
a way with the click of a button as there is with currency. This works.


Glad that worked for you. Perhaps there is a clever custom or other
format that would do the trick without having to multiply by 100
explicitly, but I am not aware of it. Perhaps someone else will
respond.