Removing negative sign from excel column
I was recently writing an excel document for generating reports, but somehow the application converted one whole column of my data to negative values. I tried searching on internet and found one good method I wanted to share.
- Write -1 somewhere and copy it (using Ctrl+C)
- Select the column (or select the particular boxes) you want to make changes to.
- Go to paste menu and select “paste special”.
- Select “All” and “multiply” and press OK.
- Done, that’s it. 🙂
The columns selected will be multiplied with -1 and the values will be stored there.