CODEWITHSUNDEEP
google-sheets
Richard de Ree
Richard de Ree

Reputation: 2550

Google spreadsheet point or comma always comma as decimal divider

There is always trouble with google spreadsheet once it comes on data entry of numbers. When use the US keyboard every keystroke works fine, except the point, which need to be a comma. You can change this by ctrl+shift or any other methode. However, it's a pain for everyone who need to switch between different keyboard country layouts.

What I want is a function what always makes a comma as decimal seperator, no matter what keyboard layout the user use. 

T4 = cell with data entry
=CONCATENATE(left(T4;len(T4)-3);",";right(T4;2))

This formula works, until the data entry is something like 12.3

Anyone an idea how to make this work in all situations?

Upvotes: 0

Views: 7978

Answers (2)

Wicket
Wicket

Reputation: 38373

Try =VALUE(SUBSTITUTE(A2;".";","))

Upvotes: 3

Ed Nelson
Ed Nelson

Reputation: 10259

Try just formatting the input number(T4) 1,000.12 through the format menu.

Upvotes: 0

Related Questions