"How To Excel" Mini-Tutorials by TheExcelAddict.com "Helping Average Spreadsheet Users Become Local Spreadsheet Experts" How To Use Fractions In Excel Bet you thought you couldn't use fractions in Excel. Well, as a matter of fact, Excel does do fractions, but at first you may find it a little tricky entering them. If you enter 1/2 in a cell, Excel will interpret this as a date and automatically format the cell as a date. To enter a fraction that Excel can recognize, you have to precede your fraction with a zero and a space, for example 0 1/2. Excel will now recognize this entry as a fraction, store it's decimal equivalent in the cell and format it to display as a Fraction. Why not print (CTRL+P) this tip and share it with your friends and associates? Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm. You'll be amazed how much time you'll save just by learning a few of these tips. Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict)