change sign of a column of figures from + to -

[Judith]

That's it really
Visa account downloads with expenditure in positive figures, I want to put
it into spreadsheet as negative without creating another column.

 

[David Biddulph]

Put -1 in a spare cell. Copy. Select the cells you want to change from +
to -. Edit/ Paste Special/ Multiply.
You can now delete the -1 from the spare cell if you wish.

 

[Mahen]

That's it really
Visa account downloads with expenditure in positive figures, I want to put
it into spreadsheet as negative without creating another column.

In a blank cell, type -1.
Then with the cell selected, copy the -1.
Then select the range of numbers for which you want to reverse the
sign and do a >paste special >multiply.

 

[rrunya89]

That's it really
Visa account downloads with expenditure in positive figures, I want to put
it into spreadsheet as negative without creating another column.

It works pretty well...awsome