Decimal numbers

Hi all again,

Does somebody have an idea how to make from for example 34567 the decimal number 34,57 in calc?

Thanks! :slight_smile:

Such number looks like a date value on spreadsheets.

Right click on the cells to change, select Format Cells, under Category select Number and choose the format you want from the options, or define your own format.
Click the help button in the Format Cells dialog for more information.

Applying a number format to a cell does not change its underlying value.

You can get cell A2 from =ROUND(A1/10)/100 where A1 is the source cell and A2 the target cell. You also need to format cell A2 to 2 decimal places.

If I understood correctly you want to change the actual value of the cell. So either edit the cell and insert the decimal comma (assuming your decimal separator is comma), or in another cell enter 1000, copy that to clipboard, and on the target cell paste special (Shift+Ctrl+V) and select Divide. The latter comes handy if more than one cell’s value is to be divided by 1000.

Hi man, I have to use point decimal separator.
Regarding the second part, yes, I have to change a lot of cells value and I if I understood you correctly,
I think that may be the solution for my problem. I will try it. Thank you.
Beste Grüße

Here is an extract from the help file for formating numbers, no modification of the value, if you want this.

Thousands Separator
Depending on your language setting, you can use a comma, a period or a blank as a thousands separator. You can also use the separator to reduce the size of the number that is displayed by a multiple of 1000.

Number Format Format Code

15000 as 15,000 #,###

16000 as 16 #,

See also this question

Hi man, It’s not so easy :smiley: The problem is that I can’t use “,”, because our system doesn’t recognize it like decimal numbers, but instead, well like thousands. I must use “.” instead. :slight_smile:

First thing is that a number or a text?

In case the first step is to make sure is a number through =VALUE(x) where x is the cell with your data
Now you have the number 34,567.0 (or 34.567,0 depending on your locale)

Next bit I suppose is divide it by a thousand according to your request =VALUE(x)/1000
Now you have the number 34.567 (or 34,567 depending on your locale).

If you format the cell as a number with two
decimals you will see it as you want, but the number is actually the one with three decimals.
To make sure that the number is the desired one, and not only appears as, you can use a rounding functions depending on your needs, like this one:
=ROUND(VALUE(x)/1000;2)

Now the cell has 34.57 (or 34,57)

If this answers your question please remember to mark it so for the benefit of all the community. Thanks

I am not sure if I understood you correctly. I must use “.” for the decimal numbers (see my comment above). These decimal numbers should be weights by the way.