| 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 |
| 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) | |||
Threaded Mode
