Changing positive values to negative

[jay]

I’m using excel 2007with windows xp pro. I use excel very infreuently and
not since upgrading to 2007.
I have a long column of dollar values that I need to change from positive to
negative values such as:
$123.45
($123.45)
I can accomplish the feat manually over many hours by F2>.HOME>- > ENTER>
DOWN ARROW and repeat and repeat and repeat. Or I can use a macro. But
using a macro has changed from years ago. When I tried the macro inserted a
specific value of cell rather than the value of the selected cell. So that
didn’t work. What can make this conversion easier?

 

[Sandy Mann]

If they are all positive values then enter -1 in a cell and then copy it.
Now highlight the range of values to be changed to negative, right-click and
select Paste Special > Multiply.

This will change all positive value into negative ones and, the reason that
I said were they all positive, all negative values will be come positive.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[jay]

THANKX

If they are all positive values then enter -1 in a cell and then copy it.
Now highlight the range of values to be changed to negative, right-click and
select Paste Special > Multiply.

This will change all positive value into negative ones and, the reason that
I said were they all positive, all negative values will be come positive.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk