Opportunity:  In the context of validating numeric fields viz.

              html ....spreadsheet's ...etc ...a good idea is to
              treat such data entered as text ....then convert to numeric
              ...viz. trap or catch the error .

              a simple illustration is in javascript or vbscript use val of a text field
              a numeric value present in the field causes or raises a error.
             

Note: The above problem statement having been encountered in various scenarios
      and detailed in various 'Proof of concepts' as mentioned in 
      
       http://uk.geocities.com/ravivenkatus/projects.pdf
       http://ravishankarkv.tripod.com/projects.pdf
        ....apply appropriate
      'use-case' modeling, rationalize and arrive at a workable and feasible 
       solution both commercially and techinically viable.

             

           


 
             