To do this, with the 1% cell still copied, select the cells containing the values you want to convert from whole numbers into ...
You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.
It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.