Forum Discussion
How to Remove Time Stamp from Date
Good Morning, As seen in the picture below I need to remove the time stamp from these cells. I've have tried just changing the number format for that colum but it wont work. I feel like I've wat...
Select E5:E26.
Make sure that the selection is formatted as a date.
On the Data tab of the ribbon, click Text to Columns.
Click Next >, then click Next > again.
In step 3, select Date, then select MDY from the drop-down next to it.
Click Finish.
Repeat for F5:F26.
HansVogelaar Thanks for the reply but that did not work for me following your steps exactly. Is there anything else you could suggest or maybe I could send you the file? I have no idea why this is not working.
If you can attach a sample workbook to a reply, please do so. Otherwise, upload it a OneDrive, Google Drive, Dropbox or similar, then obtain a link to the uploaded file and post the link in a reply. Thanks in advance.