How do I remove the time from date and time picker

Copper Contributor

I have managed to put a date/time picker into a cell. However, when I select the drop down and choose a date, the current time auto populates in there. How can I change that so that just the date shows? Picture posted.

Thanks!

5 Replies

Thank you for your reply. I am working in Excel 2016 and this does not seem to be the way to fix it. :(

 

ok
I will help you. don't worry
:)

hi

please go through the attached file .