Thread: How to switch negative numbers to positive numbers in Excel ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
  
Posts: 510
Default How to switch negative numbers to positive numbers in Excel ?
Hi

Enter -1 into some free cell and copy the cell.
Select the range with numbers, you want to change.
Select PasteSpecialMultiply

Remove -1 entered at start.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"amashmallow888" wrote in message
...
Need to switch positive numbers to negative numbers (or vice versa) in
Excel
worksheet efficiently, anyone can help me here?


Reply With QuoteReply With Quote