Protect sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I protected a certain range but I would also like to disbale any entry in that area that is not in number format, HOW
I know it is possible, I've seen in but don't know how to do it

Thanx

Ivic
 
Ivica,

If you mean allow only numbers, try Data -Validation - Whole number or
Decimal.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Ivica said:
Hi,

I protected a certain range but I would also like to disbale any entry in
Click to expand...
that area that is not in number format, HOW?
 
Back
Top