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.
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-2018 (c) Shyam Pillai. All rights reserved.