How do I show negative figures as positives.

shrek

Board Regular
Joined
Dec 16, 2005
Messages
244
I have a workbook in which I export to excel sheetsheet. When their pasted is shows it as negative figures. I actually need them as posiitive figures.

Is there any quick way I can change them automatically.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

If they are all negative, enter -1 in a cell, select this cell, then EDIT --> COPY --> select the destination cells, right button click, select PASTE SPECIAL, select MULTIPLY.
 

Gohar Shahab

Active Member
Joined
May 17, 2006
Messages
339

ADVERTISEMENT

you Can use

=ABS(A1), it will convert the negative value to positive.

Gohar
USING XL 2003
 

Tulyena

New Member
Joined
Sep 18, 2006
Messages
1
I have a similar issue. I copy and paste data into excel from another program, but the program I copy from displays everything as its opposite value. So I need to be able to convert all the positives to negatives and vice versa in Excel. I've tried using the suggestions above and they do work great for converting negatives to positives, but the positives stay positive. I'd really appreciate any ideas!
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,053
Office Version
  1. 365
Tulyena:

onlyadrafter's suggestion will toggle values between positive and negative.
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
I have a similar issue. I copy and paste data into excel from another program, but the program I copy from displays everything as its opposite value. So I need to be able to convert all the positives to negatives and vice versa in Excel. I've tried using the suggestions above and they do work great for converting negatives to positives, but the positives stay positive. I'd really appreciate any ideas!
To maintain an audit trail, I would use a separate column (or columns as the case may be). Suppose your data are in a single column (A) starting with A2. Then, in B2, enter =-A2.

Now, copy B2 as far down B as you have data in A. The easiest way would be to move the cursor over the bottom-right corner of B2 and double-click.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,128
Messages
5,857,531
Members
431,884
Latest member
Gcmoore63

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top