Hi Thapelo,
Not sure if this is the only possible solution, but I would approach this issue by doing the following:
1) Select the whole column (e.g. "A"), Custom Cell Format (Ctrl+1) -> Type: dd/mm/yy hh:mm
2) Again, select the whole column (e.g. "A") -> Data Validation -> Custom -> =ISNUMBER(A1)