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

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

Dear

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

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

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

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.

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

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

Use CSV excel format to remove DR and CR

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

Go to Number Configuration and add prefixes as (-) and (+)  as needed and remove suffix.

Don't forget to restart Tally.