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






Picture showing selecting the range of cells in excel

Click to Enlarge







Picture showing the Find and Replace window for removing the time

Click to Enlarge





Picture showing removing the time element from the date string

Click to Enlarge


Approach 2






Picture showing selecting the range of cells in excel

Click to Enlarge



Picture showing selecting the General option from the dropdown

Click to Enlarge



Picture showing the dates are converted into numbers

Click to Enlarge









Picture showing Find and Replace window for removing decimals

Click to Enlarge





Picture showing removing the decimal and numbers after decimal

Click to Enlarge



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