MAX/MIN functions on cells formatted as Percent.

[Swiatkowski Peter]

Hello,

I am able to use MAX/MIN functions on cells formatted as Numbers, however
not on cells formatted as Percent.

How can "some" function be used to convert Percent to Numbers so that
MAX/MIN function can be used ?

Peter

 

[Peo Sjoblom]

No difference, percentage = numbers unless you use text, if so copy an empty
cell, select the percentage and do edit>paste special and add
That will convert it as well, otherwise format as percentage

 

[Ron Rosenfeld]

Hello,

I am able to use MAX/MIN functions on cells formatted as Numbers, however
not on cells formatted as Percent.

How can "some" function be used to convert Percent to Numbers so that
MAX/MIN function can be used ?

Peter

There is no reason why you should not be able to use MAX/MIN functions on cells
formatted as percent.

You are possibly entering an improper formula, or not understanding the nature
of your data.

For help, please post your formula, your inputs, your expected outputs, and
your actual outputs.


--ron

 

[Don Guillett]

percent is numbers>should work.