How can i filter data type in a cell?
 

I need that an especific cell, only accept numbers or date. Thanks

How can i filter data type in a cell?
 

look up data validation in Excel's help.

it's under Data-Validation

On Jun 3, 2:07 pm, blauerhund
wrote:
I need that an especific cell, only accept numbers or date. Thanks

How can i filter data type in a cell?
 

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




On Jun 3, 11:21*pm, Tim879 wrote:
look up data validation in Excel's help.

it's under Data-Validation

On Jun 3, 2:07 pm, blauerhund
wrote:



I need that an especific cell, only accept numbers or date. Thanks- Hide quoted text -

- Show quoted text -