Devide by 10

[andonny]

Hi,
Is it possible to devide all numbers positive and negative in a column when the column is selected or do I need a macro.

Thank you for your help
Andonny

 

[brucesw]

Andonny,

You can use Paste Special.

Type 10 into a cell then copy (edit/copy)
Highlight all the "destination" cells and then select Edit/Paste Special
Select Multiply from the options in the window. Then OK.

Hope that helps.

 

[Barry Katcher]

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