Ask Your Question

different decimal separator in the same document? [closed]

asked 2013-06-11 17:38:28 +0200

Ljiljan gravatar image

updated 2015-11-02 04:44:36 +0200

Alex Kemp gravatar image

how it is possible to have different decimal seperator (both "." and "," in the same document?)

The same formula is applied and the formula works perfectely, but in some cells "." is used as decimal seperator while in some ","

Any idea what I can do to fix this problem?

I am using Calc on Ubuntu 13.04

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-02 04:44:55.980702

1 Answer

Sort by » oldest newest most voted

answered 2013-06-11 18:42:06 +0200

Pedro gravatar image

updated 2013-06-11 23:43:36 +0200

Yes, it is possible. Check that the cells are formatted to the same Language (under Format, Cells, tab Numbers, Language)

However when all cells are set to the same Language, if there are two separators they have different meanings. e.g if the Cell Language is set to English US 1,200 is one thousand two hundred units while 1.200 is one point two units (with three decimal cases).

edit flag offensive delete link more


thanks for clarifying this for me... I was working at home (where local language settings were set) and then edited document at work (where English language settins were set)... I guess this is the reason cell language is changed...

Ljiljan gravatar imageLjiljan ( 2013-06-11 22:12:30 +0200 )edit

Question Tools


Asked: 2013-06-11 17:38:28 +0200

Seen: 639 times

Last updated: Jun 11 '13