Dear Experts

In worksheets("Table")
I want to apply following format

Cell C1=must accept NUMERIC value as 99,999
Cell C2=must accpet CHARACTER value
Cell C3=must accept DATE value as dd-mm-yy
Cell C4=must accept LOGICAL value as Y or N

Please help with VBA codes.