A nice trick you can pull with Edit / Paste Special / Multiply is assuming you had table of values, whether they be hardwired or formulas, and you wanted to multiply them all by a value from another cell, but leave it such that you could change that value:-
Assuming data table in A1:H100, in say cell K1 put a number, eg 1, and then in any other cell put =$K$1. Copy the cell you just put that in, select the table A1:H100, do Edit / Paste Special / Multiply and then delete the cell with the formula. You will now have all your cells linked to K1 and can change the value in it at will and see it reflected in changes to all the values in your table.
Another trick is to use it to coerce textual 'numbers' from text format back to numerical format. Put a 1 in a cell, ensure it is numeric, select your text 'numbers' and then paste special / multiply to convert them all.