asked on
removing all time stamps from the dates throughout the column in each cell
I have the following in my cell 7/12/2019 11:32
Each cell contains different dates and time stamps
I would like to get rid of the timestamp in every cell and just keep the date. I dont want to have to type in each date
Thanks in advance
Each cell contains different dates and time stamps
I would like to get rid of the timestamp in every cell and just keep the date. I dont want to have to type in each date
Thanks in advance
Microsoft ExcelMicrosoft Office
Last Comment
Martin Liss
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You could also use the integer function =INT(number), and format the result as a date.
Lastly you could use Text to Columns and use a "space" as the delimter.
You could also use Power Query to change it on an ongoing basis in the event your need is a continuing issue.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks!
You’re welcome and I’m glad I was able to help.
If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2019
Experts Exchange Top Expert VBA 2018, 2019
Experts Exchange Distinguished Expert in Excel 2018
If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2019
Experts Exchange Top Expert VBA 2018, 2019
Experts Exchange Distinguished Expert in Excel 2018