View Single Post
  #2   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 perce.

heine7515 wrote:
I want to do an average in percentages but I do not want the percent symbol
to show in the cell. Is there a way of doing this?


If I understand you correct, the solution might be as simple as to
multiply your formula by 100. You might also need to format the cell
to, for example, Number with 2 decimal places (Format Cells
Number). If this is not sufficient to satisfy your needs, I suggest
that you explain your requirement better and include a numerical
example.