Become a Govt. Certified GST Practitioner. Batch begins 18th Nov. Register Now!

Conversion of cr/dr to -/+ in export to excel

ageeem (student) (18 Points)

06 May 2012

how to convert Dr/Cr to + / - , during tally data export to excel

Reply
Follow
Share

9 Replies

Ms.Shrikala V Deodhar (IPCC student) (93 Points)
Replied 06 May 2012

u need to format by using relpace option...i.e.select and press Ctrl + F and replace the signs u want to..try in rough eport sheet first

Upgrade to CAclubindia Pro. Subscribe Now!

V P Narasimhan (Accounts Manager) (791 Points)
Replied 15 November 2012

Dear

After export you can format the numbers wherein the Credits can be given in ( xxxxx) in Drs. a/c & in vice versa.

Ibrahim (student) (27 Points)
Replied 23 December 2013

Dear Excel Experts,

I am also curiouse to find out solution about Coversion of "Cr" to minus.

This is required to be done if data is exported from "Tally to Excel"

Is any body having solution for this type of task?

Regards,

Ibrahim

NOUFAL (ACCOUNTANT) (762 Points)
Replied 26 December 2013

It is very simple to do by using the excel format cell

Please make a new custom cell format by using the

Go to - Format Cell - Custom (type = 0.00;-0.00)

press ok

To convert to Dr; Cr

in format cell - Custom (type= 0.00 "Dr"; 0.00 "Cr")

press ok

Rahul (Accounts Manager) (39 Points)
Replied 14 March 2016

Here is a way.

1) Place your cursor on cell D3 and go into the Define Name (Formulas -> Define Name/Name Manager)
2) Ener Name as "CRDR" (of your choice if you want) and under "Refers to" enter this formula =Get.cell(7,!C3)
3) On Cell D3, enter =CRDR, this should display the custom format applied on the cell like (0.00 "DR").
4) Enter the same formula =CRDR on all the Cells on D column
5) Apply autofilter on the D column, using custom filters, filter as desired.

Upgrade to CAclubindia Pro. Subscribe Now!

Prodip Das (xx) (427 Points)
Replied 30 March 2016

You may refer the following link where the matter already shared by me:

/forum/convert-tally-exported-cr-as-negative-in-excel-344117.asp

Manoj Kumar (Consultant) (34 Points)
Replied 22 August 2016

Use CSV excel format to remove DR and CR

Vishal Dhoka (Article Assistant) (32 Points)
Replied 03 June 2017

Go to Format Cell... Delete "00:00 cr" format, then all Cr entries would show amount without "cr". Example "1100 cr" to "1100", Then Use formula "=cell("format",a3), this will show "F2" on "Dr" entries and show "G" on entries you deleted format "1100". This will create point of Distinction. Use IF function to further go for +/- values

1 Like