Désincrivez-moi no comprender english !!!!! 2008/5/19 TechAdmin @ VibrantLivingMinistries < [EMAIL PROTECTED]>:
> From: Johnny Rosenberg [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 18, 2008 1:25 AM > To: [email protected] > Subject: Re: [users] Small problem with Calc. > > 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 > -------------------------- > I find this conversation helpful, thanks to all. Question: Can someone > explain what "Precision as shown" actually does? > Thanks, > Elchanan > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
