How to remove dr and cr in excel

Last updated: 23 January 2021
Quick Summary
This guide provides a simple, step-by-step method to remove 'DR' and 'CR' suffixes from your Excel data, making it easier to analyse financial figures. It covers replacing 'DR' with nothing and 'CR' with a minus sign, followed by converting these into proper negative numbers. This is perfect for anyone working with trade receivables or similar financial data where these suffixes hinder analysis.

File details
DOCX 115 KB 0 downloads Technology & Tools
File description
Remove dr and cr in excel in a few simple steps. #docx
Download DOCX 115 KB Like
Submitted by · Posted 23 January 2021 · Other files by Nikita Agarwal · Report
Comments

Recent Files in Technology & Tools

View more →
XLSX

How to Show Text after Value in Pivot Table

26 May 2025 Download
XLSX

Extract Company Name & CIN No. from NCLT E-Mail - Working IBBI

05 June 2025 Download
PDF

Project & Task Management - Google Sheet Template

07 April 2025 Download
PDF

TASK MESTRO - Free Google Sheet for Task & Project Management

27 March 2025 Download
RAR

Form 16A PDF Email Sender Utility

06 December 2024 Download
RAR

Import PDF Bank Statement in Tally Prime / Tally 9 / Tally 7

05 December 2024 Download

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Pro Member Amit PurohitAmit PurohitPro Member Varun DhimanVarun DhimanPro Member Ankur RiswadkarAnkur RiswadkarPro Member ketul vakilketul vakilPro Member SIVALINGAMSIVALINGAM
Subscribe to Pro
Join an elite circle of professionals


Popular Files


  1. RBI Bulletin - September 2026
  2. Developments in India's Balance of Payments for the m/o July 2026
  3. ICSI | Exposure Draft of Proposed Syllabus 2027
  4. CA Intermediate Financial Management and Strategic Management Paper New Course September 2026
  5. FAQs on Agricultural Income (Section 2(5) and Rule 270) as per IT Act 2025
  6. FAQs on Tax Audit as per IT Act 2025
  7. FAQs on TAN as per IT Act 2025

Latest Job Openings

View all
Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
ARTICLESHIP 07 September 2026
CA Articles

Kothari Jain Patil & Chartered Accountants

Pune

CA Inter

View Details
Company
Featured 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details