View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mahen Mahen is offline
external usenet poster
 
Posts: 8
Default 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.