May 24, 2011

Microsoft Excel 2007 - Inserting Fractions

When you enter a fraction into Excel, it converts the fraction to something else.  For example when you type 1/4 Excel converts it to January 4.  This can be annoying when you really want to enter a fraction.

A quick and easy fix is to add a zero and a space before the fraction.  For example 0 1/4 will stay as 1/4.

Try it!

No comments:

Post a Comment