How to set decimal no........

Vicky.gupta · Posted: Sat Mar 03, 2012 2:21 am Post subject: How to set decimal no........

i have problem in Calc Decimal no.
Eg

23.432
32.43
it use 3 or 2 degit after the point.
plz solve

floris_v · Posted: Sat Mar 03, 2012 2:57 am Post subject:

Select the cells you want to have the same format, then Format - Cells and set Decimal places (under Options) to the value you want.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum

Vicky.gupta · Posted: Fri Mar 16, 2012 9:48 pm Post subject:

Thank you.

But my problem is that when i apply a formulas it pick up different value
i show you.......

my value is 23.157

and change that 23.16

but when i applying formula is for calculating no. it pickup 23.157 value.........

sol this problem......

floris_v · Posted: Sat Mar 17, 2012 1:24 am Post subject:

In that case you have to round the numbers to two decimals. You have to do that explicitly because rounding means introducing errors. So it's your responsibility to use the Round function as in Round(3.14576;2).

Please put some thought into your post and try to make your question as clear as possible to somebody who is not sitting beside you and can't see what's going on in your mind.

If your problem has been solved, please edit the first post in this thread and add [Solved] to the title bar.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum