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.
Originally posted 2008-12-08 08:45:00. Republished by Blog Post Promoter
If you enjoyed this post, make sure you subscribe to my RSS feed!
0 comments ↓
There are no comments yet...Kick things off by filling out the form below.
You must log in to post a comment.