how can i get the date & time format 2010/02/17 12:05 in excel

  • Thread starter Thread starter NarenSelva
  • Start date Start date
N

NarenSelva

I would like to share my knowledge by improving & clearing my doubts.
 
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 + ;
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare dates in two different ranges 1
Highlight date nearest to TODAY() 1
Need difference in Hrs.mm.ss 3
move two columns of data to four columns 1
Arranging dates in a single column 5
Move two columns to four columns 2
Pivot Table Summarizing Quirk - Please Help 1
Count specific days in between dates 2

Back
Top