2008/3/16, Alex Janssen <[EMAIL PROTECTED]>: > > Радимир Мирчев said the following on 03/15/2008 10:02 AM: > >> Hello Sun :) >> >> I use OpenOffice.org [Calc] and is very happy with its functionality. But >> I had a problem, I hope for your help. When I enter the sum, for example - >> 164,848, the program rounds off the sum on 164,85, tell please how to switch >> off this function, these figures - the prices, and they should not will be >> brief. >> >> Best regards! >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> When entering, don't enter the comma (,). > Just the numbers 164848. > The comma is being interpreted as the beginning of the fractional part of > whole units of money. > Check your language settings for monetary input and display under > Tools->Options->Language Settings->Languages, decimal separator key and > default currency. > > HTH, > > Alex > > > The Russian comma (I guess the OP is Russian due to his/her email address) is a decimal comma, just like in many other countries (like my country, Sweden), right? So the comma is absolutely not supposed to be omitted. And it seems to work too, since 164,848 is correctly rounded to 164,85. If you don't want the comma to be a decimal comma, but rather a thousands separator, then you can select another language or whatever, but I am not sure if that's the problem.
Радимир Мирчев, Look at the buttons on the top of the Calc window, on my system I will look at the second row of buttons. There is a button with some coins on it. The third button to the right of that one and also the fourth one is for setting how many decimals you want (again, on my system, maybe those are located different on yours). One of them increases and the other one decreases the number of decimals. There are also may other ways to change it. You can also set whether or not the set number of decimals should be used in calculations. Click Tools → Options... → OpenOffice.org Calc → Calculate → Make sure that the checkbox for "Precision as shown" is NOT ticked. If you now enter 164,848 in A1, 254,245 in A2, and then sum these in A3, A3 will now show 419,09 (if all cells are set to showing 2 decimals). Tick the "Precision as shown" box and A3 will show 419,10, and I guess that is not what you want. So just make sure it's unticked. Johnny Rosenberg
