Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
Entering Fractions In Excel Worksheets.
Posted by - NA - on 30 March 2006 07:54 AM
|
|
|
Solution: Have you ever entered a fraction in an Excel cell and had it appear as a date? This is not a bug. The problem occurs simply because, in some cases, Excel has no way of knowing whether you want to enter a date or a fraction. For example, if you enter a whole number plus a fraction (1 5/8, 2 1/4) Excel knows you want a fraction. But, if you enter 3/64, Excel will think you want to enter March 1964. If you enter 3/6, Excel will display March 6. To make sure Excel sees your entry as a fraction, you can enter fractions such as 3/64 as ? 3/64 which Excel will interpret as the fraction 3/64 (0.184615384615385) rather than March 1964. | |
 (136 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)