Convert negative numbers in place

If you only need to convert negative numbers once, you can convert in-place with Paste Special: The video on this page shows this technique and many other paste special shortcuts.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.