Right click the cellFormat cellsClick Custom and enter the below format

yyyy/mm/dd hh:mm

Now try entering a date in that cell. To enter todays date use the short key
Ctrl + ;

--
Jacob


"NarenSelva" wrote:

I would like to share my knowledge by improving & clearing my doubts.