About Us

Jay

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?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing a cell color to reflect positive or negative total	Alex Vega[_2_]	New Users to Excel	4	May 27th 07 03:25 PM
Changing formuals from Positive to negative	relliman	Excel Discussion (Misc queries)	4	November 27th 05 03:34 AM
Formula to make Negative Values Positive & Positive Values Negative?	mustard	Excel Discussion (Misc queries)	4	September 26th 05 10:05 PM
Changing Positive to Negative	Matthew Hackett via OfficeKB.com	Excel Worksheet Functions	2	June 28th 05 11:55 AM
simple query changing set of numbers from positive to negative	sammy	Excel Discussion (Misc queries)	2	May 1st 05 11:06 PM

Menu

About Us