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.