Epinn, that's not what the Operations are for.

They were there before hyperlink's existed.

remember KIS

Steve

On Tue, 10 Oct 2006 08:41:49 +0100, Epinn
wrote:

Deactivate several hyperlinks at once
1.. Type the number 1 in a blank cell, and right-click the cell.
2.. Click Copy on the shortcut menu.
3.. While pressing CTRL, select each hyperlink you want to deactivate.
4.. Click Paste Special on the Edit menu.
5.. Under Operation, click Multiply and then click OK.
The above is from Excel Help. This is one example of using multiply.

I also use multiply by 1 to convert numbers in text format (i.e. left
aligned in a cell) to number format (i.e. right aligned). "Add 0"
achieves the same.

Epinn

"David Biddulph" wrote in message
...
"Avadivelan TCS" wrote in
message
...
Hi All,

In the PASTE SPECIAL ,what is the use of
OPERATION(Add,Sbtract,Multiply,Divide)
radio button. can anybody expliain with example.
Thanks in advance for your reply.

If you have a cell with the value 3, for example, if you copy that cell,
then select a range of cells and use Paste Special/ Multiply, it will
multiply the value in each cell in the selected range by 3.