I want show date and time in my excel in automatic

In my excel date and time does not show so please tell how to solve this problem and give solution

Dear Learner,
Welcome to LearnVern! We are happy to serve you.

You can Select Column then, Goto Home> Cells - Format, Format Cells and under Category: select Custom and in Type: enter dd-mmm-yy hh:mm AM/PM

We hope our reply serves your query well.
Keep learning.


Thanks and Regards,
Monik
Team LearnVern.