Home

Changing numbers into negative or positive depending on the number condition

%3CLINGO-SUB%20id%3D%22lingo-sub-658261%22%20slang%3D%22en-US%22%3EChanging%20numbers%20into%20negative%20or%20positive%20depending%20on%20the%20number%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658261%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20change%20a%20large%20group%20of%20numbers%20from%20negative%20to%20positive%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-658261%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-658318%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20numbers%20into%20negative%20or%20positive%20depending%20on%20the%20number%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658318%22%20slang%3D%22en-US%22%3EEnter%20-1%20in%20a%20cell.%20Select%20that%20cell%20and%20press%20Ctrl%2BC.%20Select%20the%20group%20of%20numbers%20you%20want%20to%20change%20from%20negative%20to%20positive.%20Press%20Ctrl%2BAlt%2BV%2C%20select%20Multiply%2C%20and%20click%20Ok.%3C%2FLINGO-BODY%3E
Jack007
New 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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies