> Date: Tue, 27 Oct 2009 19:04:37 -0700 (PDT) > From: Jella <arts...@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 _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
