Convert dr / cr to values in tally exported file

Sir, Attached is the file.

Please suggest me some formula to separate the number 1087 Dr as shown in Colum E. By Pressing F2, i could not see the same text format as showing in the Column

Kindly help me out. Thanks 

hi

Runmacro given by me, after that change number format of all cell in col. D or col. E. All Dr. values will get changed to positive & vice versa.

Thanks

Good Macro  Vaibhav, can we copy this macro in our  excel work book or  do we need to  used it int your sheet only

whether this formulae can be used for 100 of rows

Originally posted by : Gopalkrishna Hegde ,CA,DISA
	whether this formulae can be used for 100 of rows

Hi

You can run on any no. of rows, you can copy your data in this sheet & Run macro on it..

Do  let me know if you need any help.

Thanks

Thanks You, Can please help me to convert debit to minus in excel after downloading from tally   by any of  the macros 

@ gopalkrishna

Check attachment..

Best!

VaibhavJ

you may use this link as well https://www.ashishmathur.com/extract-text-from-a-custom-formatted-cell/

Originally posted by : kumaravel d
	you may use this link as well https://www.ashishmathur.com/extract-text-from-a-custom-formatted-cell/

It has limitattion since it works on particular column only..

pls help me to replace dr & cr sign with plus & minusin op bal & closing bal.

as I'm not able to do with macro which you provided.

pfa excel sheet

From Manoj

Convert "Dr" or "Cr" contained data into CSV format (under excel save as option) and data can be modified with excel options.

Convert "Dr" or "Cr" format excel file into CSV form under save as option of excel, then you can modify exce data based on user requirments.

Hi,

No need to write any macro, use excel CSV format to remove DR and CR

Regards

Manoj

Thanks 

That is much easier and time saving