Forum Discussion
Help with formula's and drop down lists
Okay that is clear. What if I use the decimal instead of comma? will that allow me to not need the source column F shown? I ask because I would prefer not to have the source colom so that it can't accidentally be changed by someone trying to use the sheet. If the answer is yes, how do I go about changing it all so that the system settings are the same and I don't need the extra column.
The advantage of using a range as source for the drop-down lists is that it will keep on working if the end user has a different decimal separator than you - Excel will automatically switch between point and comma as needed.
If you specify the list directly in the Data Validation dialog, it won't work with a different decimal separator.
You can place the source range on a different worksheet, and hide that sheet. That way, the user won't be able to edit the list. See the attached version.
HansVogelaar Oh that is a great tip and one I will use!
Thanks so much for your help and patience in this matter!