Change the Format to Hide the Time from Timestamp
- Select the cell in which you have the time stamp from which you want to remove the time.
- Hold the Control key and then press the 1 key. ...
- In the Format Cells dialog box, select the Number tab.
- In the left pane, click on the Date option.