Question: how to change date format in excel to remove time?
Answer: Select the column. Choose Format Cells. Choose number and set decimals to 0. Click Ok. ...  Choose Format Cells again. Choose date and mm/dd/yyyy. Click Ok and your dates are back, but without times.