Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1206
  • Last Modified:

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
0
PachecoPrimo
Asked:
PachecoPrimo
1 Solution
 
StephenJRCommented:
How does it get there?! There is no formula or code.

You can use a formula =TODAY()
0
 
barry houdiniCommented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now