Need to make Excel use comma as a default delimiter if I drag a .csv file to Excel window or select a .csv file from Windows Explorer. None of the suggestions on this site or combinations therof have worked. In Control Panel - Regional Settings - System Separators I have set comma as the default delimiter and set space character as thousands separator. In Excel I tried using System Separators and NOT using System separators with Decimal set to dot . and Thousands set to a single space, so that comma would only be used as delimiter, but nothing seems to work.
We have hundreds or workers each opening dozens of .csv files each day and it's much easier to do this from Windows Explorer than from inside Excel and having to set comma delimiter each time.