If all you want is to show the date and not the date and time both, you can easily do that by altering the format of the cells in Excel. Remove Time From Date using Text to ColumnsĬhange the Format to Hide the Time from Timestamp.Remove Time From Date using Find and Replace.Remove Time from Date in Excel Using Formulas.Change the Format to Hide the Time from Timestamp.
