Can I reverse a column ?

[Karl]

Is there a way to reverse all the plus in a column into negative and the
negative into plus?

I mean a fast way, not manually all and every entry by hand.

 

[Niek Otten]

In an empty cell, enter the number -1. Edit>Copy. Select your numbers.
Edit>Paste Special, check Multiply. OK.

 

[J.E. McGimpsey]

One way:

Enter -1 into a blank cell. Copy the cell. Select your column.
Choose Paste Special, selecting the Value and Multiplication radio
buttons. Click OK. Clear the cell with -1.

Fast enough?

 

[Karl]

Thanks for the reply.

I use Excel 97 and I do not see Paste Special. I see Paste, but not special.

Is 97 that different from 200 or 2002 ? Or I am to blame, I must say, I am
very much a newbie as far as Excel goes. So additional help is very much
appreciated.

Thanks in advance

Karolus

 

[Karl]

I did find Paste Special but it has a Radio button for Paste and then to the
left Unicode Text.

Is that what I should click on?

 

[J.E. McGimpsey]

Look in the Edit Menu

 

[J.E. McGimpsey]

Try copying your cell again. Sounds like you copied from some other
text source.