How to Multiply a Column of Numbers Times a Percentage in Excel. Microsoft Office Excel includes dozens of function options to help you automatically generate values in cells across a spreadsheet.

On paper, you multiply this number by 100 to convert it to the percentage "50%." Excel does not recognize this conversion and simply displays "50," which can cause problems in other calculations.