Convert dr / cr to values in tally exported file

Tally 16508 views 24 replies

Hi

 

After exporting file from tally in to excel all Dr /Cr values are shown as positive number only, so when we try to add or subtract number we get undesired result.

 

I have crreaed macro taht will convert Cr value as negative keeping format intact.

 

Do post if you have any query.

 

Thnaks!!


Attached File : 112266 1331797 tally convert dr cr.xls downloaded: 4296 times
Replies (24)

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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register