Hello Excellers, welcome back to another #Exceltips blog post in my 2021 series. I wanted to share this Excel tip with you as it really is a fast way of converting a list of positive Excel numbers into negative numbers. You may receive data from another source that contains positive numbers. They may need to be converted from positive to negative. t using the Paste Special feature in Excel.
I have a data set here of numbers, which are refunds, they therefore should be all negative numbers in this data extract.
Follow these quick steps to convert your numbers
- Type -1 in a nearby cell
- Copy the -1 value
- Select your range of numbers
- Go to Paste Special | Values | Multiply | Ok
Once you hit Ok, your values will be multiplied by -1.
This converts them to negative numbers – easy huh. Why not try it?.
If you want to read all of my Excel Tip from my Macro Monday and Formula Friday Series then click on the links below.
How To Excel At Excel – Macro Mondays Blog Posts.
How To Excel At Excel – Formula Friday Blog Posts.
If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.
