Ask Your Question

Decimal numbers

asked 2017-01-05 11:41:32 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi all again,

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

Thanks! :)

edit retag flag offensive close merge delete


Such number looks like a date value on spreadsheets.

m.a.riosv gravatar imagem.a.riosv ( 2017-01-05 23:04:48 +0200 )edit

5 Answers

Sort by » oldest newest most voted

answered 2017-01-12 17:13:26 +0200

EasyTrieve gravatar image

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.

edit flag offensive delete link more

answered 2017-01-05 12:01:22 +0200

robleyd gravatar image

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.

edit flag offensive delete link more


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

erAck gravatar imageerAck ( 2017-01-12 17:54:03 +0200 )edit

answered 2017-01-12 18:40:59 +0200

horst gravatar image

updated 2017-01-12 18:47:52 +0200

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

edit flag offensive delete link more


Hi man, It's not so easy :D 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. :)

MrGeminus gravatar imageMrGeminus ( 2017-05-03 15:46:47 +0200 )edit

answered 2017-01-14 08:29:38 +0200

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

edit flag offensive delete link more


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.

MrGeminus gravatar imageMrGeminus ( 2017-05-03 15:51:03 +0200 )edit

answered 2017-01-12 17:53:24 +0200

erAck gravatar image

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.

edit flag offensive delete link more


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

MrGeminus gravatar imageMrGeminus ( 2017-05-03 16:06:13 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-05 11:41:32 +0200

Seen: 1,511 times

Last updated: Jan 14 '17