Articles → EXCEL → Remove The Time From A Date And Time Cell In Excel

Remove The Time From A Date And Time Cell In Excel






Excel File




Picture showing the sample excel file with the date data

Click to Enlarge




Approach 1




  1. Select the range of cells.
  2. Picture showing selecting the range of cells in excel

    Click to Enlarge

  3. Press CTRL + H to open find and replace window.
  4. In the ‘Find What’ textbox, enter ‘ *’.
  5. In the ‘Replace with’ textbox, keep it blank.
  6. Picture showing the Find and Replace window for removing the time

    Click to Enlarge

  7. Click on ‘Replace All’ button.


Picture showing removing the time element from the date string

Click to Enlarge


Approach 2




  1. Select the range of cells.
  2. Picture showing selecting the range of cells in excel

    Click to Enlarge

  3. Go to the ‘Number’ section of the ‘Home’ ribbon and select ‘General’ from the drop down.
  4. Picture showing selecting the General option from the dropdown

    Click to Enlarge

  5. Data is converted into numbers.
  6. Picture showing the dates are converted into numbers

    Click to Enlarge




  1. Press CTRL + H to open find and replace window.
  2. In the ‘Find What’ textbox, enter ‘.*’.
  3. In the ‘Replace with’ textbox, keep it blank.
  4. Picture showing Find and Replace window for removing decimals

    Click to Enlarge

  5. Click on ‘Replace All’ button.
  6. Decimals are removed from the number.
  7. Picture showing removing the decimal and numbers after decimal

    Click to Enlarge

  8. Now again go to the ‘Number’ section of the ‘Home’ ribbon and select ‘Short Date’ from the drop down.
  9. Picture showing selecting the Short Date option from the dropdown

    Click to Enlarge




Picture showing removing the time element from the date string

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Friday, December 21, 2018

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250