Forum Discussion

Jack007's avatar
Jack007
Copper Contributor
May 30, 2019

Changing numbers into negative or positive depending on the number condition

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

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    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.

Resources