#1   Report Post  
Posted to microsoft.public.excel.misc
Andy
 
Posts: n/a
Default Fractions

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   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default Fractions

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to prevent Excel converting imported fractions into dates Phil A in the UK Excel Discussion (Misc queries) 6 March 28th 06 08:03 AM
Using the AND function with fractions [email protected] Excel Worksheet Functions 1 October 18th 05 03:24 PM
Changing proper fractions to improper. apersonoutthere Excel Discussion (Misc queries) 1 April 15th 05 07:24 AM
fractions turn into dates when pasting in excel 2003 Eddie Spaghetti Excel Discussion (Misc queries) 5 March 24th 05 03:07 PM
How do I import fractions without data being converted to dates? rproeber Excel Discussion (Misc queries) 1 December 6th 04 12:53 AM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"