[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Vicky.gupta
Newbie

Joined: 03 Mar 2012
Posts: 3
Location: Indore (India)

 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
Moderator

Joined: 12 Jul 2007
Posts: 4619
Location: Netherlands

 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
Newbie

Joined: 03 Mar 2012
Posts: 3
Location: Indore (India)

 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
Moderator

Joined: 12 Jul 2007
Posts: 4619
Location: Netherlands

 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum