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.

About these ads
Explore posts in the same categories: Uncategorized

Tags: ,

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

3 Comments on “Removing negative sign from excel column”

  1. vinod Says:

    Thumps up

  2. Thida Says:

    Good! Thanks u


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: