Glide Training Logo

August 2012

Changing a negative value into a positive value in Excel

Written by Jane Hames

I was doing some analysis on my banking this week (hmmm, not the most exciting job!) and decided to export the month’s transactions into Excel so that I could separate my incomings and outgoings more easily. The outgoings were displayed as negative values which is what I would expect. However, I wanted to be able to subtract my outgoings from my incomings to check the balance.

Read more on Changing a negative value into a positive value in Excel…