+ Reply to Thread
Results 1 to 11 of 11

Debit credit formulas

  1. #1
    Registered User
    Join Date
    03-17-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    26

    Debit credit formulas

    Hi, I have a sheet in which I have done somehting which is changing numbers in italics to Credit and rest as debit?
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Debit credit formulas

    It seems you custom formatted the Debit cells as: ""0.00" Dr" and the Credit cells as ""0.00" Cr"
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    03-17-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Debit credit formulas

    How do I fix this?
    Quote Originally Posted by NBVC View Post
    It seems you custom formatted the Debit cells as: ""0.00" Dr" and the Credit cells as ""0.00" Cr"

  4. #4
    Registered User
    Join Date
    03-17-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Debit credit formulas

    How do i identify the formula usd here?

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Debit credit formulas

    They are not formula, they are formats.

    Right click any cell and select Format Cells and then go to the Number tab.. you will see the chosen format is custom and the type is as mentioned above.

  6. #6
    Registered User
    Join Date
    03-17-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Debit credit formulas

    Thanks I feel stupid

  7. #7
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Debit credit formulas

    No need to feel stupid... sometimes it's the simple things can drive you mad... I've had those situations too...

  8. #8
    Registered User
    Join Date
    03-17-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Debit credit formulas

    See i understand that we have that format here but if I have to change it to a format where it will show me that the one in CR is (-) and one in + is a debit. the situation is I cant sort it or filter it as debits and credits with the current format. How do I change them into a format where I can work on the file

  9. #9
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Debit credit formulas

    As it stands you cannot sort by credit/debit.

    What you will need to do is go to all the ones that are supposed to be Debits and enter a - in front of the number.

    Then select the whole range and go to Format Cells and custom format as:

    0.00 " Cr";0.00 " Dr"

    then you will be able to sort...

  10. #10
    Registered User
    Join Date
    03-17-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Debit credit formulas

    I have a thousand line items how do I do it manually? Any ideas or shortcuts?

  11. #11
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Debit credit formulas

    I think someone will have to come up with a VBA macro to do it for you (I am not a VBA expert).. as I don't think there is a way in native Excel to determine which of the 2 formats you have and to change the CR to -ve.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1