An easier way to enter fractions in Excel

Enter fractions into Excel without formatting

Not too long ago, Mary Ann Richards told you to enter a fraction in Excel by formatting the cell first. Why should you bother? Well, if you don't, Excel interprets a fraction as a date. For example, if you enter ½, Excel returns 2-Jan. Now, Mary Ann suggested that you format the cell first, which definitely works and might be the most appropriate way to go. However, for a quick fix, simply enter a 0 before the fraction. For instance, to enter the literal fraction ½, enter 0 ½ instead (there's a space between 0 and ½). It works like a charm!


Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox