LibreOffice ver 188.8.131.52
Windows 7 Home Premium
I am studying various methods of calculating square roots. When I put =(3.33+3)/2 in a cell, the answer is shown as 3.17. I added decimal points to the general number format. This just gave me 3.170000. To 4 decimal places the correct answer is 3.1667 according to the website I am looking at. I tried the answer given in LibreOffice Help, but it doesn’t work. Somehow with the changes I made, it rounds to 3.165000 now.
So here is what I need to do. I can round numbers in my head. So, if I need to, I can go through the mental anguish of rounding 1.667384 to 1.67 if I need to. But, I want the cell to show me 1.667384 when I am doing the calculation. As simple math like I showed (3.33+3)/2 — not having to use a function or something. I’m just wanting to use the cell as a calculator. If this is not possible, I’m sure I can find a calculator on the internet that will allow me long decimal precision. Now I’m going to have to figure out how to get rid of the changes if someone answers this question. Thankfully there are reset or default buttons in the dialogs so I can probably get it back to the way it was.