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