Changing positive values to negative

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jay - 06 Jul 2007 17:14 GMT

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?

Reply to this Message

Sandy Mann - 06 Jul 2007 17:34 GMT

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.

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> I'm using excel 2007with windows xp pro. I use excel very infreuently and
> not since upgrading to 2007.
[quoted text clipped - 10 lines]
> that
> didn't work. What can make this conversion easier?

Reply to this Message

jay - 07 Jul 2007 01:34 GMT

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
[quoted text clipped - 17 lines]
> > that
> > didn't work. What can make this conversion easier?

Reply to this Message