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