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 |