Yes, multiply by -1. But if you want to just change a whole group, you could
just type a -1 in some random cell and copy it (ctrl + C). Then select the
cells you want to change and Edit Paste Special, select the 'multiply'
radio button and click OK.

"relliman" wrote:


hi

I believe there is a way that you can change values on screen that are
positive to negative or vice versa!!

I would be really grateful if someone could tell me how??!!!


--
relliman
------------------------------------------------------------------------
relliman's Profile: http://www.excelforum.com/member.php...o&userid=29105
View this thread: http://www.excelforum.com/showthread...hreadid=488276