I'm working to create an automated way to QA some pharmacy reports and one of the QA steps is to check that a data element is formatted as currency. Is there a way to create a formula to detect that so I can add "Pass" or "Fail" automatically without you manually looking at the cell?
Last edited by kelasmith; 08-12-2011 at 03:43 PM.
Use:
Please Login or Register to view this content.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
Perfect! Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks