Need help with lines of numbers!%20This%20is%20my%20first%20time%20on%20this%20community%20so%20hope%20I%20am%20doing%20things%20correctly!%3C%2FP%3E%3CP%3EIs%20there%20someone%20who%20can%20assist%20me%20please%20in%20how%20I%20can%20change%20a%20number%20of%20lines%20from%20negative%20numbers%20to%20positive%20ones%3F%20I%20work%20on%20windows%2010%26nbsp%3B%20and%20office%20365%20for%20excel%20so%20using%20latest%20option.%20Am%20on%20%22normal%20computer%22%2C%20not%20apple.%20will%20be%20appreciated%2C%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2465286%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor


Hi All! This is my first time on this community so hope I am doing things correctly!

Is there someone who can assist me please in how I can change a number of lines from negative numbers to positive ones? I work on windows 10  and office 365 for excel so using latest option. Am on "normal computer", not apple. will be appreciated, thank you!

2 Replies


Select an empty cell.

Enter -1 in that cell.

Copy the cell (Ctrl+C).

Select the range of cells with negative numbers.

On the Home tab of the ribbon, click the lower half of the Paste button and select Paste Special...

Alternatively, right-click anywhere in the selected range and select Paste Special... from the context menu.

Select Multiply, then click OK.

You can now clear the cell in which you entered -1.

Hi @KittyKey92016110159092 


If you don't need to keep the initial negative values:

  • Select the cells containg the negative values you want to change to positive values
  • CTRL + H
  • Replace what: -
  • Replace with: don't enter anything

If you need to keep the initial negative values, one option given you use Excel 365 - in a free cell:

  • Enter =ABS(
  • Select the cells containing the negative values
  • Add a closing the parenthese

This should look something like: =ABS(A2:D6)


NB that there must be enough free cells around the cell where you enter the above formula, otherwise you'll get a #SPILL! error. With the above example where 4 columns (A-D) and 5 rows (#2-#6) are involved there must be an area of 4 consecutive columns and 5 consecutive rows of cells free of any value. Hope that's clear otherwise let me know