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?

2 Answers 2


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


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy