I have an Excel spreadsheet with some sort of generated data. This spreadsheet is then presented to a user who is supposed to fill in some numbers. Then there is a column with a simple sum of user inserted data.
The problem is that eventhough all of my users are in central Europe which uses comma(",") as a decimal separator, some of them still use dot(".") as a decimal separator. Excel then treats this cell as a datetime and there's no way user can switch cell format back to number (spreadsheet is password protected and most of cells are locked).
My question is: Is there a way to treat both dot and comma as a decimal separator? I can't use VBA and the column with a sum of user typed values has to be there (eg. converting cells to text won't help me, I guess, because sum does not work on text cells).