View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Counting Cell with Quotation

Instead of trying to account for input errors after entry, why not use Data
Validation to ensure that only valid numbers are entered?

Select the input cells
DataValidation
Allow: Whole Number
Data: Between (set the limits)
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"scott" wrote:

In my ss operators enter in numbers to change settings at times the
operatortors forget that all they have to enter is whole numbers and add the
quotation marks. Is there a way to count these quotation marks.
Example--should be 10 they enter 10' or 10"

Thanks Scott