Thread: Changing groups of cells in Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default Changing groups of cells in Excel
Hi
In a spare cell type -1
Copy the cell
Select your range of data
Paste SpecialMultiply

--
Regards
Roger Govier

"DBB9" wrote in message
...
In Excel 2003 can I change a group of cells (e.g. a column) so their
results
all become negative or do I have to change each cell individually?

Reply With QuoteReply With Quote