Inserting negative sign into a range of numbers

[AM Fernandez]

Dear All

I have a list of numbers in my excel sheet and i want to convert them to negative numbers. Please see below for the details:-

Current
2.00
2.00
34.00
1.00
3.00
4.00
4.00

Convert to
-2.00
-2.00
-34.00
-1.00
-3.00
-4.00
-4.00

Can someone help on this?

Thank you.

[davesexcel]

In a different cell enter -1
Then select that cell and Copy.
Select the other cells you want to be negative, then right click and select Paste Special, check multiply then OK.

[Paul]

Hi AM,

Put the number -1 into any empty cell. Copy that cell. Select your range of cells with numbers, right-click the selection and choose Paste Special, then choose Multiply and click OK. You can then delete the cell with the -1.

[protonLeah]

never mind.

[AM Fernandez]

Thank you very much. It works.

[vlady]

if you want formula

=IF(A1>0,A1*-1,"")

again multiplying by -1

[AM Fernandez]

Thank you for sharing Vlady.