banner_ad

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

This query is : Resolved 
Profile Image

Profile Image

(Querist)
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...?
Profile Image

@VaibhavJ

Profile Image

@VaibhavJ (Expert)
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!!
Profile Image

Vishnu Saboo

Profile Image

Vishnu Saboo (Expert)
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
Profile Image

@VaibhavJ

Profile Image

@VaibhavJ (Expert)
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


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
07 May 2026
CA Assistant

amit desai and co

Mumbai

CA Final

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
11 May 2026
Post office

Post office

Anakapalle

Others

View Details
Company
ARTICLESHIP 17 May 2026
CA Article /Trainee

Malik Sunil & co

New Delhi

CA Foundation

View Details