Open Office Help

In column C, right click and choose format cells, then click percentage.
Adjust decimal places as you wish

Then in C1 enter =a1/b1

* =b1/a1

In excel you would put (in the top box of column C) =(b2/a2)*100 and then copy/paste it down the whole column

I know open office isn't the same, but I suspect it is for simpler functions like this one.

Do as starfish says, ignore me

cheers guys, finally got it working. only taken me 80 minutes :D

The great thing now though, is that learning excel/open office is a continual building process. You've not just got this working, but you'll be able to do similar, but slightly different things really quickly

If you needed a column to add numbers together, you'd do it in 2 mins now, not 80, and so on.

that's very true lori and a good mind set to have.