How do I remove the time from date and time picker

Question

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!

gourab dasgupta · Answer

okI will help you. don't worry:)

gourab dasgupta · Answer

HiHope this&nbsp;is exact what you need.&nbsp;https://support.office.com/en-us/article/change-how-a-date-or-time-is-displayed-in-a-date-picker-text-box-or-expression-box-281563ad-af67-44f5-bd2d-e4a3403d05d4

shannon mudler · Answer

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

gourab dasgupta · Answer

hiplease go through the attached file .&nbsp;

shannon mudler · Answer

Thank you!

Forum Discussion

How do I remove the time from date and time picker

Resources