Changing numbers into negative or positive depending on the number condition

Copper Contributor

Is there a way to change a large group of numbers from negative to positive?

1 Reply
Enter -1 in a cell. Select that cell and press Ctrl+C. Select the group of numbers you want to change from negative to positive. Press Ctrl+Alt+V, select Multiply, and click Ok.