Forum Discussion
Anonymous
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.
JKPieterse
Jun 12, 2019Silver Contributor
This is far from simple to make absolutely 100% secure, as it is easy to break a conditional formatting rule by a simple copy and paste.
One way to make pasting harder is by merging two cells next to each other before setting up the Validation on the merged cells, unlocking the merged cell (and setting a date format) and then protecting the worksheet.
One way to make pasting harder is by merging two cells next to each other before setting up the Validation on the merged cells, unlocking the merged cell (and setting a date format) and then protecting the worksheet.
Anonymous
Jun 12, 2019Also, I can use the 'Excel Date Picker Add on' then let the users pick up a date, however, this would require the users to have the add on installed on their systems. So trying to figure out if by any way I can keep the users from entering data in a wrong or different format.