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

Type the 10 in some random cell and copy. Select your target cells and Edit
Paste Special, and select the Multiply radio button.

"RTimberlake" wrote:

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

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 editpaste special and select
multiply

--
Regards,

Peo Sjoblom

(No private emails please)


"RTimberlake" wrote in message
...
Is there a way to multiply all values in my spreadsheet by 10? If so, how?

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.

"RTimberlake" wrote:

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

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

"Sloth" wrote:

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.

"RTimberlake" wrote:

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