Dear sir the same problem is faced by all of us who r useing data to export in excel we can not use 'dr' as filter command as when we go to the cell which contains numbers it only shows no. Not number with the term 'dr' or 'cr'. It becomes a cellformat as like of currency sign with number in excel.
We all tally users will be immensely grateful if it solves how to segregate the 'dr' number and 'cr' number. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -----Original Message----- From: "dguillett1" <dguille...@gmail.com> Sender: excel-macros@googlegroups.com Date: Wed, 5 Oct 2011 07:26:57 To: <excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Thanks everyone. You should never “hijack” a thread to ask a question. Instead, start your own with a new subject line. However, can you not use data>autofilter>custom>ends with DR? From: P.VIJAYKUMAR Sent: Tuesday, October 04, 2011 8:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Thanks everyone. Dear Ayush , Congrats on your second achievement, I have a problem with excel.Generally I work with Tally and Excel.When I export accounting Data into excel, I am getting the data with debit and credit along with the number i.e I am getting the data in custom format ( 0.00 Dr). It is not possible to select only debit(dr) or only Credit (Cr)figures at one shot. As it is not possible to select by conditional formatting or by other mode we are selecting the required numbers using filters but that to is a very time consuming and tedious task as the data could range into thousands of numbers and selecting each one using a filter is atime consuming task.I would be truly grateful to you and the group members if any helpis offered in this regard. Regards, VIJAY KUMAR -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
