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

ASKER CERTIFIED SOLUTION

Tom Farrar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tom Farrar

You could also use the integer function =INT(number), and format the result as a date.

Tom Farrar

Lastly you could use Text to Columns and use a "space" as the delimter.

Tom Farrar

You could also use Power Query to change it on an ongoing basis in the event your need is a continuing issue.

SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Patricia Timm

ASKER

Thanks!

Martin Liss

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