about as simple as it gets or ?

[chris dunn <chris iccqs com>]

> Date: Tue, 27 Oct 2009 19:04:37 -0700 (PDT)
> From: Jella <artsci2 yahoo com>
> Subject: about as simple as it gets or ?

> To get a set of positive numbers pasted as negative is easy.

> Select your array of positive numbers, right click and copy, select
> the upper left cell where you wanat the negatives to appear, right
> click and select "paste special" and then click on "subtract. viola!

> john


John,

Thanks for this pearl of wisdom. I guess this is the "correct" way to
achieve the right result. Just need to be certain that the destination
cells are empty otherwise confusion reigns.

This also provided a useful pointer to the use of paste special. I
hadn't explored or used it much up to now, but I now see that there is
a lot of power in the paste special with the exercise of a little
thought and planning.

Viola or violins, or voila. Thanks again.

-- 

Chris Dunn