To do this, with the 1% cell still copied, select the cells containing the values you want to convert from whole numbers into ...
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 ...