I never bothered. You can get around it using either pivot tables or the
SumProduct Formula... Here is a link to sumproduct.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Using either of these two methods you can segregate the debits from the
credits and get the totals that you want.
--
HTH...

Jim Thomlinson


"Tim Childs" wrote:

Hi

Moment of laziness? surely not.

Has anyone written a short proc. to convert bank entries which are text
ending with " Dr" and " Cr" into the numerical equivalent. I did do a Google
search but did not find anything useful

Thanks

Tim