Formatting currency on Apache Open Office. Edit. Solution given.

Belenus

How do I format this table so it shows a second zero after the decimal point.

11.10 shows as 11.1, 5.20 shows as 5.2 etc.

I have tried all the obvious tools. Auto Format/Currency adds colours to all the cells.

Month paid	Standard	Travel eating	Total
Jul	5.08	6.02	11.1
Aug	3.65	24.54	28.19
Sep	2.37	17.5	19.87
Oct	5.2	15.98	21.18
Nov	2.86	13.3	16.16
	19.16	77.34	96.5

Vitor

1. Select the cells containing the amounts.
2. Right-click and choose Format Cells (or press Ctrl+1).
3. Select the Numbers tab.
4. Choose Number and set Decimal places to 2.
5. Click OK.

MyRealNameToo

A screenshot of the tool bar would have been helpful. Should be an icon thats like a 0.000 with either a plus or an arrow next to it depending on which version your on. Think like excel its a bit odd as the lead 0 is on a different line to the decimal and following zeros

Belenus

Thanks Vitor. That worked,