On Nov 6, 7:33 pm, Pete_UK wrote:
You really want to divide all these numbers by 100 - formatting won't
affect the values. Put the number 100 in an empty cell somewhere, then
select that cell and click <copy. Then highlight all the cells (or
columns) that you want to change and click on Edit | Paste Special |
Values (check) | Divide (check) | OK then <Esc.

You can then delete the 100 from the first cell.

Hope this helps.

Pete

Pete, Thanks sooooo much that's awesome and it worked like a charm.
I'll add the step to the macro and voila! Thanks so much for your
help. E