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 ...
Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.