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.
|