Change date/time

[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!

 

[Bob Westdyk]

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

Bob W

 

[Mike]

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