Forum Discussion
Setting one fixed format of date in Excel Cells
Hello there, I'm trying to set only one format of date acceptable into excel cells. In no instance a user shall feed in a different format of a date or even if he/she does, Excel sheet must be ab...
Deleted Here's en example using this code.
Thank you so much, I think I got what I have been looking for.
I have used the following URL to set up the date picker in Excel, which has been successful. However, I couldn't get the required format which is mm-dd-yyyy. I have used the same VBA code as in the URL. Could someone please help?
https://github.com/Amallard/excelTricks/blob/master/DatePickerToCells.md
Thanks,
Karthick.S
- Best to include your file (scrubbed of any sensitive information!) so we can see what you tried.