The macro that you obtained from excelforum just multiplies all the column K values by 100. Your description suggests that you did not want just that.