change sign of a column of figures from + to -
On Jan 26, 11:48*pm, Judith wrote:
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.
|