Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...

In a program like Excel, which is designed to handle numbers, you'd expect to be able to use fractions without any hiccups.

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 ...