Forum Discussion
Deleted
Jun 12, 2019Setting 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...
- Jun 13, 2019
Deleted Here's en example using this code.
Deleted
Jun 12, 2019
So it looks like I'll have to depend on VBA for this. Any idea what the code would probably look like?
JKPieterse
Jun 13, 2019Silver Contributor
Deleted Here's en example using this code.
- DeletedJun 13, 2019Thank you so much, I think I got what I have been looking for.
- DeletedJun 17, 2019
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
- JKPieterseJun 18, 2019Silver ContributorBest to include your file (scrubbed of any sensitive information!) so we can see what you tried.