Is there a way to get rid of negative numbers in Microsoft Excel?

Question

I have Excel 2003 and there's a report that i need to pull numbers from and for some unknown reason the numbers are negative when they shouldn't be, but I can't do anything about that, the report is generated that way. BUT the negative numbers are messing up the chart I want to make. Is there a way that I can make the numbers be absolute value or make the numbers not appear to be negative without manually having to change them in the report?

Answer 1

try abs(), that's the formula for absolute numbers. Good luck.

Answer 2

Negative Number Chart

Answer 3

Using the format will maintain the number as negative and they will plot that way. The abs() has to be inserted in each cell, making it laborious (unless you know how to program it). Try the following:

Edit
Replace
Find what: -
Replace with:

That should remove all of the negative values. If there are formulas, this may not work. Be selective on the cells you want, as it will remove ALL minus signs (though you can pick any range size).

Answer 4

You can make a new column that will appear in the chart. The numbers in the new column will be, row-for-row, the absolute value of the numbers in the old column. For example if old column A had row A2 as the number -10 then make the new column H where H2 is =ABS(A2) which is 10 [I just tried it in EXCEL so I am sure] and so on down the whole A column creating a whole H column. Now in your chart where you would have referred to A2 you refer to H2 and so on down the column.

Answer 5

1.Select all the cells you want this to be applicable.
2. Right click and select "Format Cells"
3. In Number tab, from the options select "number".
4. In the "Negative Numbers" option list select a format which doesn't have a minus sign.
5. There you go !!

Answer 6

Right click on the column(s), choose Format Cells, Select "Number" from the catagory, click on the second example down "1234.10", Click OK.

Answer 7

Make a itemizing of -a million's through dragging down the column. Then replica those -a million's, click on the proper of the column that you want to develop into unfavourable, and click on paste particular, and then click the container suggested as multiply. it is going to multiply all the numbers circumstances -a million, making them unfavourable.

Answer 8

Use the following formula:

=ABS(number)

Answer 9

Cheap Online Mall ---> http://store2.w3org.pw/yqpio