J Jacob Skaria Mar 2, 2010 #2 Right click the cell>Format cells>Click 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 + ;
Right click the cell>Format cells>Click 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 + ;
