I want to write currency in the format:

₽ 3 812.23

But if I select Russia as region in the table settings and format the string

₽ 0.00

result formatted number like

₽ 3 812,23

with a comma, because the comma is default separator in Russian locale. How to change comma to dot?

  • You have tagged with Google spreadsheet. Please read the description. It's off topic
    – Dave
    May 11 '16 at 6:02

How to change comma to dot?

Use Edit, Find and Replace...

Find and Replace

However the result is a text string, so you might need to substitute dot with comma if to calculate with the result.


Go to "File" > "Spreadsheet settings" and modify the "Locale".

  • 2
    Hi Spiros, could you elaborate on your answer? What should the locale be set to? Aug 30 '18 at 12:57