Easy Office
LCI Learning

Remove "dr", "cr" from excel sheet exported from tally

This query is : Resolved 

14 July 2014 when i Export data from tally fig comes with "Dr" or "Cr".
i want remove "Dr" "Cr" and convert the fig in Positive or Negative. How can i do it...?

14 July 2014 Hi

Refer this post: https://www.caclubindia.com/forum/convert-dr-cr-to-values-in-tally-exported-file-296177.asp

do let me know if you need any help.

Cheers!!

25 July 2014 you can used developed macro for, or you may use replace command.
Find what: Dr
Replace with :
in replace with bar dont put anything, i.e. keep it blank
do the same for Cr
but if all figures are in positive than before doing above process, separate in two column one in Dr and another in Cr


25 July 2014 did that file helped @shiv?




You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query