Hi, Andonny.
I think, if you want this to occur upon selection of the column, you'll need a SelectionChange macro.
A way you can easily do this manually is to place the number 10 somewhere in an unused cell and then copy it to the clipboard. Highlight the column or range you want to divide by it, and Edit>Paste Special, and choose "Divide".
Barry