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.
So it looks like I'll have to depend on VBA for this. Any idea what the code would probably look like?
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.