software

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
gt; Paste Special, and select the Multiply radio button.

quot;RTimberlakequot; wrote:

gt; 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 editgt;paste special and select
multiply

--
Regards,

Peo Sjoblom

(No private emails please)quot;RTimberlakequot; gt; wrote in message
...
gt; 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.

quot;RTimberlakequot; wrote:

gt; 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.

quot;Slothquot; wrote:

gt; in a blank cell, or in a cell on another sheet enter 10, and then copy the
gt; cell. Then highlight the whole sheet you want to multiply. Select
gt; Edit-Paste Special and select mulitply.
gt;
gt; quot;RTimberlakequot; wrote:
gt;
gt; gt; Is there a way to multiply all values in my spreadsheet by 10? If so, how?