How to excel in a number of negative pre-removal of a one-time

Payroll, a minus sign before the number, how can I put this one-time negative one-time, all of them removed? Replace like with a bad

find all you want to select the replacement of that data, and then right-click your mouse and select “Set format unit” and then on the left and then select the “value”, the right to select “1234.10” To determine the like! (You pay attention to the number of decimal places, above the median, a good choice) for your data in the A list.In any cell enter = ABS (A1), to drop the formula on the line.
This formula is taken Absolute meaning.To find out if the D-air bar in D1 enter = ABS (A1), to copy down, the D column is the result you want, copy, paste the election to choose A1 value.In the space of a cell input — 1 and copy it, select the minus sign to remove all the cells, right-click Paste Special ? ? ? determined by