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

Approach 1

1. Select the range of cells.


Click to Enlarge


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


Click to Enlarge


5. Click on ‘Replace All’ button.

Approach 2

1. Select the range of cells.


Click to Enlarge


2. Go to the ‘Number’ section of the ‘Home’ ribbon and select ‘General’ from the drop down.


Click to Enlarge


3. Data is 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.


Click to Enlarge


4. Click on ‘Replace All’ button.
5. Decimals are removed from the number.


Click to Enlarge


6. Now again go to the ‘Number’ section of the ‘Home’ ribbon and select ‘Short Date’ from the drop down.


Click to Enlarge