Multiply all values by 10

[Guest]

Is there a way to multiply all values in my spreadsheet by 10? If so, how?

 

[Guest]

Type the 10 in some random cell and copy. Select your target cells and Edit

 

[Peo Sjoblom]

First, make a copy of the workbook in case you make a typo or something,
then put 10 in an empty cell,
copy it, then select all values needed and do edit>paste special and select
multiply

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

in a blank cell, or in a cell on another sheet enter 10, and then copy the
cell. Then highlight the whole sheet you want to multiply. Select
Edit-Paste Special and select mulitply.

 

[Guest]

Thank you. I knew there had to be an easy way to make that work.