| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Show fraction as fraction even if answer is 1
I have excel sheet and I am trying to get data from from two diff columns. example C23 has certain value and F23 has certain value. Now after playing around, I found the fraction C23/F23 to show as fractions, but when the answer for C23/F23 comes to 1, then it shows 1. how can I have that show 10/10?
Please help asap Submitted via EggHeadCafe - Software Developer Portal of Choice Custom Sorting With IComparable and IComparer http://www.eggheadcafe.com/tutorials...ith-icomp.aspx |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Show fraction as fraction even if answer is 1
Excel cannot be made to display an improper fraction
You could cheat and use =IF(C23=F23,"10/10",C23/F23) You will need to change the cell format to right alignment Be aware that the 10/10 is text so no arithmetic can be done on it. best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Vin Sukhadia" wrote in message ... I have excel sheet and I am trying to get data from from two diff columns. example C23 has certain value and F23 has certain value. Now after playing around, I found the fraction C23/F23 to show as fractions, but when the answer for C23/F23 comes to 1, then it shows 1. how can I have that show 10/10? Please help asap Submitted via EggHeadCafe - Software Developer Portal of Choice Custom Sorting With IComparable and IComparer http://www.eggheadcafe.com/tutorials...ith-icomp.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text fraction to fraction format | Excel Worksheet Functions | |||
| How do I change fraction to fraction characters? | Excel Worksheet Functions | |||
| fraction | Excel Worksheet Functions | |||
| fraction | Excel Discussion (Misc queries) | |||
| Show two rows as a fraction? | Excel Discussion (Misc queries) | |||
Linear Mode
