• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1219
  • 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.
1 Solution
How does it get there?! There is no formula or code.

You can use a formula =TODAY()
barry houdiniCommented:
You could put this formula in B2 copied down


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

regards, barry
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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