-
In a blank cell nearby, type -1, press Enter, then copy the cell.
-
Select the cells that you want to convert.
-
Press Option+⌘+V, choose Multiply and select OK.
-
To convert negative numbers to positive, use the ABS function.
-
To convert positive numbers to negative, multiply the cells by -1.
You can also use Paste Special in Excel desktop to do this..
-
To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.