Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2005

Tip: Looking for answers? Try searching our database.

MAX/MIN functions on cells formatted as Percent.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Swiatkowski Peter - 29 Dec 2005 18:07 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.