If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|