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

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.