This free Excel macro formats a selection of cells as a Percentage in Excel. This simply changes a cell's number format to the Percentage number format. That will multiply any number by 100 in order to display the correct percentage number, which is what Excel does when you change the number format to Percent.
This Excel macro is great for quickly formatting large selections of cells, rows, or columns in Excel.
Sub Format_Cell_Percentage()
Selection.NumberFormat = "0.00%"
End Sub