How can i filter data type in a cell?

M

muddan madhu

suppose u want A1 needs to be accepts only number or date

then select A1, go to data | validation | setting tab | allow : custom
| formula : =isnumber(A1) | ok
 
Top