Thread: Divide all cells by 100

I won't go into the details of why I need this, but here is what I need to do.

I need to take all the values in rows 12, 18, 27, 33, 42, 48, 57, 63, 72, 78, 87, 93, 102, 108, 117, 123, 132, 138, 147, 153, 162, 168, 177, 183 and between columns E and BJ

and divide them by 100.

To further complicate it, these numbers are being pulled from another spreadsheet, so the formulas in the cells looks something like this.

='C:Folder1\Folder2\Folder3\Folder4\[File.xls]1'!$AN$76

The quick reason why is because I need to plot some data, some of which is formatted as a % and some of which is not. In order to accurately graph it, all of them need to be formatted as a %. But the way some of the values are linked from the old spreadsheet, they show up as values between 0 and 100, but not as a %. So when you format the cell as a % it multiplies it by 100 and the value is too large.

I suppose the other way to do this is if there is a way to tell it to format the cell as a % but not multiply it by 100.

Since they are formulas rather than values, you could select those cells and replace = with = 1/100 *

I have no clue why I didn't think of something that simple.

Thanks

We've all been there ...