Forum Discussion

cparker1976's avatar
cparker1976
Copper Contributor
Mar 12, 2024

How do I change a column of whole dollars to negative numbers?

How do I change a column of whole dollars to negative numbers?

 

  • cparker1976 

    Enter -1 in an empty cell.

    Copy that cell.

    Select the column with the positive amounts.

    Either click the lower half of the Paste button on the Home tab of the ribbon and select Paste Special... from the drop-down menu, or right-click anywhere in the selection, then select Paste Special... from the context menu.

    Select Multiply, then click OK.

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

    • cparker1976's avatar
      cparker1976
      Copper Contributor

      HansVogelaar 

       

      Thank you so much Hans for responding so quickly.........I really appreciate you and you are a Rock Star!

       

      Take care and again THANK YOU!

       

Resources