# Decimal numbers 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 close merge delete

Such number looks like a date value on spreadsheets.

Sort by » oldest newest most voted

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.

more 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.

more

Applying a number format to a cell does not change its underlying value. 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 #,

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. :) 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

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. 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.

more