Changing the dot (.) into comma (,) in Google Sheets, how do I do that? (numerical pad, in Holland, for currency)

Question

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?

Answer 1

Go to File > Settings Then set Locale to the Neatherlands.

Answer 2

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.

See Replace the decimal mark produced by the numeric keypad with a comma in Google Sheets.