Microsoft Excel Fractions Converted into Dates

For Excel 2003

You type a fraction in a cell, but it changes into a calendar date. How do you stop this from happening?

Select the cell or range of cells in a row or column. Click the Format menu, then click Cells. Click the Number tab, and then select Fraction. From the dialog box to the right of the Category box, choose the type of fraction you will enter into Excel, then click the OK button.

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.