Mayanwolfe
New Member
- Joined
- Jun 5, 2013
- Messages
- 27
Hello you helpful folks,
I have an ActiveX dropdown box from which the user may select a date formatted thusly: MM/DD/YYYY. The dates display perfectly in the dropdown list, but once one is selected, it shows up as the Excel numeral code in the box (such as 41548). How do I change this so that the selected date shows up in the form MM/DD/YYYY?
Thanks!
I have an ActiveX dropdown box from which the user may select a date formatted thusly: MM/DD/YYYY. The dates display perfectly in the dropdown list, but once one is selected, it shows up as the Excel numeral code in the box (such as 41548). How do I change this so that the selected date shows up in the form MM/DD/YYYY?
Thanks!