OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

Enter fractions/mixed numbers in a cell

You may have noticed that if you try to enter a fraction in an Excel cell, like ½, Excel will think it is a date and automatically format it as a date. To enter a fraction of mixed number, there is a little trick you need to know. To enter a mixed number:

Enter the first number. Then enter the fraction into the cell.
If you don’t put the 0 in, Excel will treat it as if you are entering a date.

To see the decimal equivalent of a fraction, click on the cell and look on the Formula bar. The fraction will display as decimal form for you!

 

Copyright 1999-2022 (c) Shyam Pillai. All rights reserved.