Negatives to Positives, Positives to Negatives

Hi There,

I'm a fairly inexperienced user of Excel and this is my question:

In my job, I am sent spreadsheets in which all the numbers which should be positive are negative, and all the numbers which should be negative are positive (except for a final "total"). It is my job to change these numbers and send the spreadsheet on to another person who doesn't like to look at them in this "reversed" format.

I was told by the person who previously had my job that I need to go through the spreadsheets I receive each month and change each number manually: from positive to negative or vice-versa. Does anyone know whether there is an easier way to do this? The areas of positive and negative are conveniently located in blocks and would be easy to select if there was a command that could change them all at once. I would very much appreciate any tips on this as it would save me hours of labour over the next year.

Cheers!

VW

Well, to change a positive to a negative and a negative to a positive, you just need to multiply the corresponding value by negative 1, correct?

So, in a blank cell on the worksheet, type -1. Right click on that cell, and hit copy. Next, highlight the numbers that you want to reverese the - for. Right click on them, and press paste special, then multiply. It will multiply all the numbers by -1, thereby switching their sign.

Let me know if tha works.

If all your stuff is data rather than the formulas, this might help. Put this in the ThisWorkbook codemodule and it will change the sign of any number you double click on.

Please Login or Register  to view this content.

Or to extend on mikes code if all the numbers you wanted changed were in column A you could use the below code. This would change them all automatically so you wouldnt have to click on them..

Please Login or Register  to view this content.