Click an empty cell. Type "=PRODUCT(50%)." Replace "50%" with the percentage by which you want to multiply your column. Press "Enter" to finish entering the percentage in the cell.

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.

How to multiply cells and numbers using the PRODUCT formula. You aren't limited to multiplying just two cells — you can multiply up to 255 values at once using the PRODUCT formula.