To remove the time portion in excel date time stamp in a cell, you have to change the formatting of the cell in Excel.
Let’s take an example and understand how we can change the excel timestamp format
For Example: – We have date including time in cell A1. To remove the time from the cell follow the below mentioned steps:-
You can see the date is showing in cell A1 without time but in the formula bar it is still reflecting the time. To remove the time permanently, we can use the “INT” formula.
INT: - This function is used to round a number down to the nearest integer.
Syntax of “INT” function: =INT (number)
Example:Cell A1 contains the number 456.25
=INT (A1), function will return 456
To remove the time on date time stamp follow the below mentioned steps:-
To conclude, you can see in the above snapshot that the date format has been converted to show only the date without the time.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.