The cells in a Microsoft Excel spreadsheet can hold various types of numerical data, including fractions and percentages. If some or all of your cells contain fractions, Excel enables you to convert ...
Fractions AND spreadsheets?!? I know, pretty exciting stuff. However, it can be tricky for novice spreadsheet creators to figure out how to display fractions in Excel. Microsoft Education has a quick ...
Q: Excel won't allow me to input fractions; I keep getting a date. What's happening? A: If you do not apply a fraction format to a cell before you enter a fraction into it, Excel will convert the ...
Q. Thanks for your advice in the September 2001 issue on converting fractions in Excel into decimal values. But how about those of us who need to do the reverse—that is, convert decimal values into ...
In a program like Excel, which is designed to handle numbers, you'd expect to be able to use fractions without any hiccups.
Left to its own devices, Excel will convert your fractions into dates as soon as you enter them in your spreadsheet. See how you can work around this problem. If you don’t apply a fraction format to a ...