Mar 26 2022 01:43 PM
Let's say you have dates in D2 and down.
If necessary, insert an empty column in column E.
Enter the following formula in E2:
=INT(D2)
Format E2 as a date, then fill down.
If you want to get rid of the formulas, select column E, copy then paste as values.
Mar 26 2022 01:51 PM
Depending on how deeply you want to make the change, you could
The easiest way is just to click on the cell(s) in question, then on the main Format menu, select Cells, and then select the date format you desire from the many choices shown.