'How to change data type and format in libre calc?

Libre office - Version: 6.4.7.2

My Libre office Calc is set to recognize numbers that are this format:

“10,12”

My problem is that my data is like this:

“10.12”

Libre thinks that it is a text when I enter.

How I can convert it into the number?

libreofficelibreoffice-calc


Solution 1:[1]

Sorry if this is supposed to be in the comment instead of answer, but I don't have enough reputation to do so...

Assuming you normally use comma as your decimal separator, then the solution you need is here (The article is written for Excel, but it works in Calc too. ): Convert European Number to US (or vice versa)

The short answer is to use the formula:

=NUMBERVALUE(A2,".",",")

This assumes your data is in A2. Modify accordingly.

IF, however, you ALWAYS want to use period for your decimal separator, then you need to check your settings.

  • Tools --> Options
  • Language Settings -> Languages
  • Decimal separator key: check Same as locale setting (assuming your locale is using . as decimal separator).

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 H3coder

Related Questions