format a number in libreoffice calc

Can do you put formatting rules into libreoffice calc?
dwcroninAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
There is a Format tab on the menu with a list of things you can do including 'Conditional Formatting'.  And you can right-click in a cell to change the formatting.
0
dwcroninAuthor Commented:
Thanks, but I saw that.  I wasn't specific enough. I think that google docs and/or excel have a function (text()?) for formatting output.  Somehow you can  specify, but I haven't gotten it to work, things like color/precision/font with brackets [] .  So you put something like [####.2] to specify the format of your number.  I don't know if that is before/after or where in relation to the cell reference ie.  A2[###.2] to format the value of "A2".
0
Dave BaldwinFixer of ProblemsCommented:
If you look again at the formatting and click on several different variations, you will see the coding that is used in a box at the bottom of the dialog window.
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

dwcroninAuthor Commented:
I don't see what you're talking about.  I included a screenshot of what I see.
Screenshot-from-2013-10-18-07-16.png
0
dwcroninAuthor Commented:
I also don't know why D4 is not the sum B4 and C4.
0
Dave BaldwinFixer of ProblemsCommented:
In your screen shot, D column appears to be the sum of B + C.  But D4 is not shown.  And you're not looking at the formatting dialog box.  If you right-click in a cell and choose 'Format Cells', you will see a dialog box.  At the bottom of the box under Format Codes is a text area that displays the formatting codes used for the different predefined formats.  You can edit that to create a custom format.

LibreOffice Calc Format Cell
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dwcroninAuthor Commented:
Thank you DaveBaldwin.  I was looking at the "Format" menu that appears if you take your cursor to the top of the screen. Actually you CAN see  D4.  The cell that I selected in the picture (for no reason)  is cell D11.  The "4" is immediately to the left of "44" in the "age" column.  No matter how much LibreOffice annoys me that it adds the numbers incorrectly, I'll quit putting 2 questions together.  It confuses everything.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
LibreOffice

From novice to tech pro — start learning today.