Link to home
Start Free TrialLog in
Avatar of PachecoPrimo
PachecoPrimo

asked on

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
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

How does it get there?! There is no formula or code.

You can use a formula =TODAY()
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial