The first time a new student enters a fraction in a cell, the number changes into a date. If you know you will be entering a series of fractions in a worksheet that will be used in calculations, change the cell format to recognize those values as fractions instead of text. Here is how to make that change.
Click Format > Cells >
The Format Cells dialog box (See Figure 1) opens displaying the Number tab
Figure 1
In the Category: box, choose Fraction
From the Type: box, choose the type of fraction to be displayed.
After selecting the type of fraction to be displayed, click the OK button to finish the task.
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 2010-02-24 06:00:10. 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.