how to convert negative value in excel formula bar

How to change negative value to positive value in Excel.?
As accounting there 's data which need to be in positive value in order to add accumulated and total execution.
But sometimes you will receive the negative value in the various types of data given by agencies.

Updated by microsoft 2016.i ve refer to youtube excel advance which approach me to use this style of converting.
Just share the way which can help you to reconcile your account nicely in excel.

=ABS (value)
Please refer to formula bar to change the value from negative to positive.
Before this i ve been working to do extra work by reconcile some of shipping company.




Comments

Popular posts from this blog

Jualan Balik ASNB Redemption Pelaburan Subscription

PURI DAN CAPATI

Pinggan sihat Malaysia..Suku Suku Separuh