Change date/time

  • Thread starter Thread starter ku
  • Start date Start date
K

ku

Hi, I have a list of dates that appear as
08/27/2003 12:01:28:666
I would like to have only the date of 08/27/2003.

Any easy, quick way to do that?

Many thanks!
 
Right click on the cell, choose format cells, then choose date, and choose
the format you want.

Bob W
 
Enter the formula =DATEVALUE(LEFT(A1,10)) in a separate cell and format it with mm/dd/yyyy.
 
Back
Top