# 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! :)

First time here? Check out the FAQ!

Decimal numbers

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

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

0

0

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.

0

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

0

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)

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

0

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.

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

Seen: **1,511 times**

Last updated: **Jan 14 '17**

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Such number looks like a date value on spreadsheets.