How to remove time from date in Excel? I have a huge amount of data where the Date columns contain dates in the format 3/3/2010 11:00:00 AM. But it is not possible to remove the time section,11:00:00 AM, using Replace or Format as Date. Is there any other way to get rid of the time section from the date.
Referred some websites such as official support! Suggestions are welcome!

