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 sho...
excel
Macros and VBA
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

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

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

 

    • shannon mudler's avatar
      shannon mudler
      Copper Contributor
      May 08, 2018

      Thank you!

  • Gourab Dasgupta's avatar
    Gourab Dasgupta
    Iron Contributor
    May 07, 2018
    ok
    I will help you. don't worry
    :)

Resources