View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Diane Diane is offline
external usenet poster
 
Posts: 1
Default Keep text out of numeric field

I am trying to "idiot proof" a worksheet. I know how to protect and
unprotect cells and worksheets...

What I am trying to do now is to make it so that someone cannot enter text
in a numeric field. I have not figured out how to do that yet. I would
think it would be rather common, but I don't see how it is done.

Thanks in advance.
Diane