Need help with lines of numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2465286%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20lines%20of%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2465286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20All!%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%3CLINGO-SUB%20id%3D%22lingo-sub-2465314%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20lines%20of%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2465314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1083522%22%20target%3D%22_blank%22%3E%40KittyKey92016110159092%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20an%20empty%20cell.%3C%2FP%3E%0A%3CP%3EEnter%20-1%20in%20that%20cell.%3C%2FP%3E%0A%3CP%3ECopy%20the%20cell%20(Ctrl%2BC).%3C%2FP%3E%0A%3CP%3ESelect%20the%20range%20of%20cells%20with%20negative%20numbers.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20click%20the%20lower%20half%20of%20the%20Paste%20button%20and%20select%20Paste%20Special...%3C%2FP%3E%0A%3CP%3EAlternatively%2C%20right-click%20anywhere%20in%20the%20selected%20range%20and%20select%20Paste%20Special...%20from%20the%20context%20menu.%3C%2FP%3E%0A%3CP%3ESelect%20Multiply%2C%20then%20click%20OK.%3C%2FP%3E%0A%3CP%3EYou%20can%20now%20clear%20the%20cell%20in%20which%20you%20entered%20-1.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

@cuong 

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

@KittyKey92016110159092 

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