Posts Tagged ‘ date ’

Numbers Entered as Fractions

February 20, 2012
By

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. Read more »

Related Articles:

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

Archives

Tags

accounting format AutoAum AutoFill AutoFit Columns close Excel column border columns not wide enough Context menu copy cells currency format currency style cursor cut and paste cells date dates Drag and Drop edit Edit menu fill series format numbers formulas fractions Functions Keyboard shortcuts mouse pointer move sheet tab move worksheet normal view numbers open Excel page break view pound symbol print active worksheet print entire workbook print list print row and column headings print selection print titles randbetween random numbers save Excel set print area sum function the " # " symbol turn on gridlines