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
Post a Comment
Terima Kasih Sudi Singgah Komen