Thread: Converting positive numbers to negative numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus Ardus Petus is offline
external usenet poster
  
Posts: 718
Default Converting positive numbers to negative numbers
Enter -1 in an empty cell.
EditCopy.
Select your positive numbers
EditPaste special, check Multiply option

HTH
--
AP

"Treg67" a écrit dans le message de news:
...
How can I convert positive numbers to negative numbers without retyping
each
entry, thanks


Reply With QuoteReply With Quote