• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change the format of Numbers

Lasantha

Member
Dear All,

Kindly look into the below numbers. I just want to show negative numbers as positive and positive numbers as negative. Could you please help me to create a formula.

Thank you for you time.

Carrier Payment
$ (240.01)
$ (49.27)
NULL
$ (160.32)
$ (160.66)
$ (17.13)
$ (81.56)
$ (156.88)
$ (125.38)
$ (51.61)
$ (142.64)
$ (172.55)
NULL
NULL
$ (35.82)
NULL
NULL
$ (41.36)
$ -
$ -
NULL
$ (123.86)
$ (4.63)
$ (17.78)
$ 548.00
$ 116.00
$ 165.00
$ 508.00
$ 508.00
$ 138.00
$ 607.00
$ 700.00
$ 371.00
$ 165.00
$ 700.00
$ 508.00
$ 116.00
$ 102.00
$ 99.00
 
Top