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

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