Prodip Das
New member
- Joined
- Dec 9, 2015
- Messages
- 3
- Reaction score
- 0
- Points
- 0
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.
Please refer the file attached herewith. I would appreciate you for solving the above problem.
Attachments
Last edited: