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
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!

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 Mikilesh ShahMikilesh ShahPro Member Anurag SharmaAnurag SharmaPro Member vinalvinalPro Member KAVITA CHAUHANKAVITA CHAUHANPro Member Vidish BhattVidish Bhatt
Subscribe to Pro
Join an elite circle of professionals


Popular Files


  1. RBI issues Consolidated Supervisory Directions
  2. RBI releases Handbook of Statistics on the Indian Economy 2025-26
  3. RBI issues Basel Pillar 3 Disclosures for Banks
  4. RBI Bulletin - July 2026
  5. ICAI Students' Journal - July 2026
  6. FAQs: Taxation and Other Laws (Amendment) Bill, 2026
Follow