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 - 29 Dec 2005 18:12 GMT
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

Signature
Regards,
Peo Sjoblom
> Hello,
>
[quoted text clipped - 5 lines]
>
> Peter
Ron Rosenfeld - 29 Dec 2005 18:14 GMT
>Hello,
>
[quoted text clipped - 5 lines]
>
>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 - 29 Dec 2005 18:15 GMT
percent is numbers>should work.

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
> Hello,
>
[quoted text clipped - 5 lines]
>
> Peter