Forum Discussion
cparker1976
Mar 12, 2024Copper Contributor
How do I change a column of whole dollars to negative numbers?
How do I change a column of whole dollars to negative numbers?
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.
- cparker1976Copper Contributor
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!