Re: about as simple as it gets or ?



Hello!
Here's one, pretty simple way.

in sheet 2, cell A1 enter (or whever your data actually starts)
=-Sheet1!A1

copy the formula down and then accross for the extent of the data on sheet 1.
Select then copy it all
edit->paste special-> check "values"

now you have a sheet with all the same numbers but negated that you can copy and paste.

Another way might be to save the data as a csv file then using your favourite scripting solution (perl, python, ruby, shell, haskell?) To read the data then write out a file with the numbers negated.


I hope this helps.

Hal
On 26/10/2009 11:17 PM, chris dunn wrote:
I want to copy a series of positive numbers to a new location.

However, when I paste the numbers I would like them to show up as
negative instead of positive.

Is there an easy way to achieve this short of pasting, and then
individually changing the values to negative?

Thanks.







[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]