How to replace dot with comma in numbers?

Question

Google Sheets

Maybe someone knows the formula for replacing a dot with a comma in a number, for example 6.60

Answer 1

First, check your regional settings in Sheets, maybe this is what you need.

Replacing Values
​​Find a search and replace in the menu and replace all dots with commas
Replacing with a formula The
best replacement formula is a formula with a regular expression
=REGEXREPLACE(B16;"\.";",")
Note that the original value must be a string.