Re: about as simple as it gets or ?

[Hal Ashburner <hal ashburner gmail com>]

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