Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change. To simplify to process, use an absolute reference ...

When you apply Microsoft Excel's percentage number format to a cell already containing a number, it multiplies the value by 100. This can be frustrating, as there's apparently no easy way to stop this ...