
#How to change a negative number in Excel with one click?
First double-click B2, enter the formula "=ABS(A2)", and press the Enter key;
Then move the mouse to the lower right corner of the cell until the cursor turns black After the cross, pull down the formula;
Finally save the data to achieve a negative number with one click.

Recommended tutorials: "PHP" "Excel"
The above is the detailed content of How to change a negative number in Excel with one click?. For more information, please follow other related articles on the PHP Chinese website!
How to change word background color to white
How to delete the last blank page in word
Compare the similarities and differences between two columns of data in excel
Why can't I delete the last blank page in word?
Word single page changes paper orientation
excel duplicate item filter color
How to copy an Excel table to make it the same size as the original
Excel table slash divided into two