Type a Fraction, get a Date!

You want to type a fraction in Excel, but always get a date. How do you break this date?

The easy way is to put a ‘0’ (zero) and a space, in front of the fraction.

But what if you are typing a long row or column of cells with fractions. It’s time-consuming to put zeroes in front of each fraction. What to do?

• Select the cells you want to change
• Click Format from the Menu Bar
• Click Cells
• Click the Number tab, and then in the Category: window, select Fraction
• Click the OK button to accept this display change.

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

Originally posted 2009-02-01 07:45:00. Republished by Blog Post Promoter