May 04 2018 01:02 PM
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!
May 04 2018 06:54 PM
Hi
Hope this is exact what you need.
May 07 2018 09:12 AM
Thank you for your reply. I am working in Excel 2016 and this does not seem to be the way to fix it. :(
May 07 2018 09:41 AM
May 08 2018 06:25 AM
hi
please go through the attached file .