 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007Cell format - fractions
I have a set of cells that show the fraction of #complete/#total. They are formatted as fractions so that I can custom format them such that those >=50% turn green and those <50% turn red. The problem is that for a completion of say 8/10, excel automatically simplifies to 4/5. Is is possible for excel to still recognize the cell as a fraction but not simplify? Format Custom as ?/10  SignatureKind regards, Niek Otten Microsoft MVP - Excel |I have a set of cells that show the fraction of #complete/#total. They | are formatted as fractions so that I can custom format them such that | those >=50% turn green and those <50% turn red. The problem is that | for a completion of say 8/10, excel automatically simplifies to 4/5. | Is is possible for excel to still recognize the cell as a fraction but | not simplify? 8/10 was just an example. It could be 3/6 or 5/15. Is there a way to do this for all fractions? Thanks! > Format Custom as ?/10 > [quoted text clipped - 10 lines] > | Is is possible for excel to still recognize the cell as a fraction but > | not simplify? <Is there a way to do this for all fractions?> To do what? When does it have to be 3/6, not 6/12, when 5/15, not 1/3? SignatureKind regards, Niek Otten Microsoft MVP - Excel | 8/10 was just an example. It could be 3/6 or 5/15. Is there a way to | do this for all fractions? [quoted text clipped - 14 lines] | > | Is is possible for excel to still recognize the cell as a fraction but | > | not simplify? I'm not sure I understand what you're asking. I want any fraction to remain as is -- even if it is in unsimplified form. > <Is there a way to do this for all fractions?> > [quoted text clipped - 24 lines] > | > | Is is possible for excel to still recognize the cell as a fraction but > | > | not simplify? < I want any fraction to remain as is> Do you mean that the fraction is not the result of a formula, but of manual input? SignatureKind regards, Niek Otten Microsoft MVP - Excel | I'm not sure I understand what you're asking. I want any fraction to | remain as is -- even if it is in unsimplified form. [quoted text clipped - 27 lines] | > | > | Is is possible for excel to still recognize the cell as a fraction but | > | > | not simplify? That is correct-- the fraction comes from manual input. Then you'll have to Custom format them with the denominator you need, like ?/15 ?/6 ?/12 etc SignatureKind regards, Niek Otten Microsoft MVP - Excel | That is correct-- the fraction comes from manual input. Absolutely wonderful! I found just what I needed in less than a minute! You're a genius! > Then you'll have to Custom format them with the denominator you need, like > [quoted text clipped - 5 lines] > > | That is correct-- the fraction comes from manual input. > I have a set of cells that show the fraction of #complete/#total. They > are formatted as fractions so that I can custom format them such that > those >=50% turn green and those <50% turn red. The problem is that > for a completion of say 8/10, excel automatically simplifies to 4/5. > Is is possible for excel to still recognize the cell as a fraction but > not simplify? Matt, You could use =A1 & "/" & B1 but it would change to text, and Excel thinks its a date. But it would look as you asked... Use conditional formatting to test the diviasion of A1/B1. beege |
Reply to this Message |
 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.