• 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.

how to convert debit amount negative and credit amount as possitive as number format with dr and cr

You cannot use normal functions to extract formatting ( at least not with XL2010)
OTOH using the little known GET.CELL hidden macro, the solution is attached ( value between parenthesis is the same as a negative value)
( the macro is embedded into Excel itself, you don't have to worry about it. Just keep saving as xlsm)
 

Attachments

  • Copy of example 2.xlsm
    10.3 KB · Views: 3
Last edited:
You must log in or register to reply here.
Back
Top