Audit-l is sponsored by Audit Leverage (IAD Solutions, Inc.) www.auditleverage.com ***************************************
Jim, This may not be the most efficient way, but it's pretty simple. The way I would do it is to insert the formula =RIGHT(TEXT(A1,"0.00"),2) where A1 is your first dollar amount (of course you can change the cell address as you need to) in a column next to the first dollar amount, and then copy the formula down for as many amounts as you have. This will give you the last 2 digits of the amount (e.g. $125.25 will give you 25 and $100.00 will give you 00). Then you can filter on this new column to show only values equal to 00, which will give you all the even dollar amounts. Any questions, just e-mail me back. Hope this helps, Sean Popock IT Audit Manager Instinet Corp. --- "Mahoney, James E" <[EMAIL PROTECTED]> wrote: > Audit-l is sponsored by Audit Leverage (IAD > Solutions, Inc.) > www.auditleverage.com > *************************************** > > Can anyone tell me if there is a way to do data > filering in Excel to check for round dollar amounts > - ie. amounts that end in zero cents such as $25.00, > $500.00, $1,500.00 etc. > > Thanks for your help > > Jim Mahoney > Sr Audit Consultant - PPL Corp > Audit Leverage is a department management software > package that integrates and automates the entire > audit process. This comprehensive package includes > risk assessment, audit planning, budgeting, > staffing, scheduling, timekeeping, automated work > papers, audit findings & recommendations, reporting > and audit follow-up. Audit Leverage allows auditors > in the field to work off-line and dial in to > synchronize their work with the Audit Leverage > database on the network, enabling managers to review > the work papers instantly without being at the job > site. > > Demo available at www.auditleverage.com > > If your organization would like to sponsor this > discussion list send an e-mail to > [EMAIL PROTECTED] for information. > > To unsubscribe to the Audit-l list send an e-mail to > [EMAIL PROTECTED] Leave the subject line > blank and include the following message in the body: > Unsubscribe audit-l (yourname) > > Thanks, > Jim Kaplan > List Manager __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com Audit Leverage is a department management software package that integrates and automates the entire audit process. This comprehensive package includes risk assessment, audit planning, budgeting, staffing, scheduling, timekeeping, automated work papers, audit findings & recommendations, reporting and audit follow-up. Audit Leverage allows auditors in the field to work off-line and dial in to synchronize their work with the Audit Leverage database on the network, enabling managers to review the work papers instantly without being at the job site. Demo available at www.auditleverage.com If your organization would like to sponsor this discussion list send an e-mail to [EMAIL PROTECTED] for information. To unsubscribe to the Audit-l list send an e-mail to [EMAIL PROTECTED] Leave the subject line blank and include the following message in the body: Unsubscribe audit-l (yourname) Thanks, Jim Kaplan List Manager
