Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Working with fractions and mixed numbers in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Fri Dec 16, 2016 7:19 pm    Post subject: Working with fractions and mixed numbers in Excel Reply with quote

It's just little bit tricky to enter fractions and mixed numbers in Excel. Just that. Let's make it easy.


Fractions

When you enter any fraction like 5/6 or 7/8 in your cell, Excel interprets these fractions as date and automatically format the cell as a date.


To enter a simple fraction:

first enter 0 and a space (after entering 0 hit the spacebar)

now enter your fraction number so it will be like 0 5/6 (as an example)

hit Enter. It's done.





The decimal value of the fraction is shown in the formula bar.







Fractions with more than one digit


In the above example we were dealing with fractions up to one digit, so what about fractions with two or more digits like 11/14 or 217/867?


To enter these fraction numbers you have to go to Format Cells, there under Fraction you can select the type like Up to two digits for 11/14 or Up to three digits for 217/867.






However, if you enter 33/51 in your cell even you have selected the fraction up to two digits, Excel will round the fraction to 11/17 but will give you alwasys the right decimal values (you can check it on the formula bar)

To fix this problem, select the cell where you want to enter this fraction, right click > go to Format Cells.

Here, under category Custom, change # ??/?? to # 33/51. Now your cell will show exactly this value.






So while working with fractions, you will often need to play with cell formatting, if necessary customising it. That's all.



Mixed numbers

To enter any mixed number like 2 5/8:

enter the first number (here 2),

then hit the Spacebar, now enter the fraction (here 5/8 ),

Press Enter. Done!




*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group