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.

Explore posts in the same categories: Uncategorized

Tags: ,

You can comment below, or link to this permanent URL from your own site.

7 Comments on “Removing negative sign from excel column”

  1. vinod Says:

    Thumps up

  2. Thida Says:

    Good! Thanks u

  3. MUKUND Says:


  4. Jon Says:

    Perfect. So easy!

  5. Tarique Says:

    Thanks bro

  6. Vaibhav Thorat Says:


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: