How to remove time from date in excel

admin

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