Forum Discussion

shannon mudler's avatar
shannon mudler
Copper Contributor
May 04, 2018

How do I remove the time from date and time picker

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!

excel
Macros and VBA

5 Replies

  • Gourab Dasgupta's avatar
    Gourab Dasgupta
    Iron Contributor
    May 04, 2018

    Hi

    Hope this is exact what you need.

     

    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

Resources