I already managed to change the dot on numerical pad into a comma in i.e. excel. But how do I do that in Google Sheets?
One way to do that is to use an
onEdit(e) simple trigger that finds if the entered value is a text string that looks like
0000.00, and converts it to a number if that is the case.