Excel Tips & Tricks – Enter a Fraction in a Cell
by Chris Leong
When doing excel calculation, sometimes I want to display value as 1/3 instead of 0.33333. I just learnt that you can do that in Excel with just a few simple steps.
Microsoft Office Excel can display, and take data entry as, fractions as well as decimal numbers. To enter a fraction, simply prefix it with a zero and a space.
So to display the fraction one-third, type 0 1/3. This will display 1/3 but will have an underlying value of 0.33333333. The cool thing about this, is when you do a simple calculation, it will automatically convert it to fraction for you.
EG. 1/3 X 5 will convert to 1 2/3.
Try it out, I guess this is some of the hidden secrets of Excel that not many people know. At least I don’t, until now.