Thread
:
Changing positive values to negative
View Single Post
#
3
Posted to microsoft.public.excel.newusers
Jay
external usenet poster
Posts: 671
Changing positive values to negative
THANKX
"Sandy Mann" wrote:
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
Replace @mailinator.com with @tiscali.co.uk
"jay" wrote in message
...
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 With Quote
Jay
View Public Profile
Find all posts by Jay