How to change separator in google sheets?

V

vari0us2016-01-17 01:47:56

Google

vari0us, 2016-01-17 01:47:56

I need Google Spreadsheets to consider data like 10.5 as a number, in which the separator is a dot !
i.imgur.com/FTa6fRS.png

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

S

Stalker_RED, 2016-01-17
@Stalker_RED

You can put USA in File -> Spreadsheet settings -> Locale
Or customize the format of an individual column by selecting it and using the Format menu

A

AizSedaj, 2017-08-26
@AizSedaj

Switch language. In English and Russian, the separator changes from dot to comma and vice versa.

P

Philip Sedov, 2021-07-10
@philippsedov

I recommend using the regular expression
=REGEXREPLACE(A2; "[.]"; ",")