making 2 (or more) validation rules for each cell

[Guest]

I'd like to make 2 (or more) validatioi rules for each cell.

For example

ID Name Date
001 Allen 09092007
002 Steve 10092007
003 Gary 11092007

 

[papou]

Hello ali
Why not use a custom number format? eg : 000
And consider using Data validation for number limits allowed.

HTH
Cordially
Pascal

 

[Guest]

Thanks for your suggestion, papou!!

but this is just an example of my question, my real question needs 2(or
more) validation rules.

Do you have any idea for taht ? ^_^!


thanks a lot ! ^_^!