I am repeatedly seeing the decimal places vanish. I want everything to have 2 decimal places so the numbers "flow" vertically and are in their right place. Why anyone would want

5

3.25

83

243.35

where they don't align is beyond comprehension. The decimal places should be in a vertical line so you can track your numbers more easily. I added decimal places in a second example but they were ignored by this system!

I format the entire page (so the whole page is highlighted, right click it, Format Cells, Number, then select the 2 decimal place example on the list to the right. Everything looks perfect. 3.00 is correct, not 3 or 3.0 or 3.000.

A few minutes later its back to lopping off the decimal places when there are no numbers to the right of the decimal place. Does this program have Amnesia? Could I be accidentally reseting it somehow?

Obviously I'm just starting in spreadsheets and find them a horrible headache, just incredibly unintuitive. The concept is so simple yet they make everything so needlessly complex, even the simplest things. No wonder so few people are really comfortable with them. The designers have absolutely ruined the learning experience. I wonder if Apple's spreadsheet program is easier for beginners? And how does OpenOffice compare to LibreOffice and Excel and Google Docs and other office type offerings from email providers like Zoho?

And is there any way of changing the font to a mono spaced one so columns of numbers are aligned? How could a forum dealing with spreadsheets miss that? Is it hiding here somewhere?