Remove time stamp from date in ms excel

I have a spreadsheet that contains a column with the date, however, the column also seems to have a time stamp concatenated to the date. I would like to remove the time stamp so that the date appears as I wanted (ex 11/01/2010). I have attached a spreadsheet for you to see what information I have.
Any assistance will be greatly appreciated.
removetimestampfromdate.xlsx
PachecoPrimoAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
You could put this formula in B2 copied down

=LEFT(A2,10)+0

that will give you just the date. Format B2 in required date format

regards, barry
0
 
StephenJRCommented:
How does it get there?! There is no formula or code.

You can use a formula =TODAY()
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.