Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
To Whom it may concern:
We collect data in a fraction format such as 5/6 or 12/12. DO I have a way to put this into one cell & have it give met he following answer 17/18 in a single cell? So basically is sums the numerator & denominator & places that into one cell. Thanks in advance for your help, everyone that participates makes my life so much easier & I really apprecaite it. -- Thanks, Andy |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You may use custom format on the cells, using the pattern ???/???. Excel
will show you the fraction, but you can make calculations with the number as usual. Be aware that it will show the simplest fraction, so 12/12 will be shown as 1/1. Hope this helps, Miguel. "Andy" wrote: To Whom it may concern: We collect data in a fraction format such as 5/6 or 12/12. DO I have a way to put this into one cell & have it give met he following answer 17/18 in a single cell? So basically is sums the numerator & denominator & places that into one cell. Thanks in advance for your help, everyone that participates makes my life so much easier & I really apprecaite it. -- Thanks, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
Using the AND function with fractions | Excel Worksheet Functions | |||
Changing proper fractions to improper. | Excel Discussion (Misc queries) | |||
fractions turn into dates when pasting in excel 2003 | Excel Discussion (Misc queries) | |||
How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) |