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

To do this, with the 1% cell still copied, select the cells containing the values you want to convert from whole numbers into percentages. If your data is formatted as an Excel table, hover over the ...