Excel Tips & Tricks – Enter a Fraction in a Cell

Featured Posts

What is a good business idea? Before answering the question, What is a good business idea? Let me ask you this question, do you need a good business idea to start your business? A long time back, my MBA professor once told me that...

Budgeting for Cradle pre-seed grant I’ve been meaning to write more about the entrepreneur scene in Malaysia, but I just can’t seems to find the time to do that. But I would like to share with any budding entrepreneurs that wants to...

Is Friendster better off with MOL? In the last post, i had talked about losing mind share in US. However, Friendster is still very strong in Asia, especially in Malaysia and Philippines. Friendster is the #11 site in Malaysia and #6...

Friendster is losing mind share in the US – Try searching... Friendster is now Malaysian. Malaysia’s MOL has just bought Friendster a couple of weeks back for an undisclosed sum. It was rumored to be at the region of USD 26 million, a large sum of money considering...

Posted by Chris Leong | Posted in Archives | Posted on 28-11-2008

Tags: Office

0

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.

Featured Posts