Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...
If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue. Remove both the Decimal and Thousand separators Numbers are ...
HowToGeek on MSN
How to Stop Excel From Changing Your Fractions
In a program like Excel, which is designed to handle numbers, you'd expect to be able to use fractions without any hiccups.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results