Results 1 to 3 of 3

Thread: How to covert Cr amount as Negative while data exported from Tally Software

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Lightbulb How to covert Cr amount as Negative while data exported from Tally Software

    I often need to export data from Tally Accounting Software to Excel. While exporting data from Tally the positive amount transferred as Dr and credit amount as Cr . However I need to show the Dr amount as positive and Cr amount as negative like (-) 10,000 or (10,000). I have tried to use function like IF.. RIGHT..SUBSTITUTE or IF..RIGHT..LEFT...LEN, but it doesn't work. Though the Dr or Cr followed by number is displaying in excel, however when i put the cursor in respective cell it shows only the number and no Dr or Cr appears. More over the range in auto sum considered the numbers as positive.
    Please refer the file attached herewith. I would appreciate you for solving the above problem.
    Attached Files Attached Files
    Last edited by Prodip Das; 2015-12-09 at 11:35 AM.

Tags for this Thread

Posting Permissions

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