Entering numbers with fractions
To enter a fractional value into a cell, leave a space between the whole number and the fraction. For example, to enter 67?8, enter 6 7/8 and then press Enter. When you select the cell, 6.875 appears in the Formula bar, and the cell entry appears as a fraction. If you have a fraction only (for example, 1?8), you must enter a zero first, like this: 0 1/8—otherwise, Excel will likely assume that you’re entering a date. When you select the cell and look at the Formula bar, you see 0.125. In the cell, you see 1?8.
// Related Posted - GOOGLE!
Loading
Related Websites
- FIFA World Cup 2010: a first group recap of matches [/caption] Written by Nick Doms All the group members have played at least one match in the FIFA World Cup...
- Ten Things I Hate About Monster.com's Job Search I decided to bite the bullet and begin the job search again. The first step in this process was to...
- California Fishing Report: May 29, 2009 The Feather River, which runs into the Sacramento Bay, is experiencing a number of schools milling around the confluence, and...
- Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all...
- Excel How-to: The GETPIVOTDATA Function In a previous post, we created a simple pivot table from a list of Excel data. Today, we'll link the...
