changing from negative to psitive 1

[juggers]

Hi all,

I have a colum that contains numbers , i want to change the positive numbers and make them negative and vice versa but i don't want to make a new colum i tried to muptiply by -1 and the display the result on the same colum ..excal is giving some cycle error..any soluation that .

Regards

time is the father of truth

 

[TonyJollans]

Hi juggers,

Don't know exactly what you did, but ..

Find an empty cell somewhere and enter -1 in it.
Copy the cell
Select your numbers
Edit > Paste Special > Multiply
Press Enter
Delete the -1 from your helper cell.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[SimonDavis]

You can't make a formula to do a calculation on data in its own cell, if thats what you're trying to do . . .

When you write the formula, you trash the data you're trying to work on. Simply can't do it.

You can, as TonyJollans said, temporarily use another column - you could also just put in column b =-a1, where column a is the original data, copy it down, hilite and copy, paste special, values, into column a. Then delete column B.

 

[Dsuperc]

Download this tool

http://www.asap-utilities.com/

Its frss and got lots of tools, includung what you are looking for