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.