I use Open Office and wanted to change some text to Title Case (Where Each First Letter Is A Capital Letter) In many programs you have a Change Case option in the Format menu. Here you would usually find Title Case, as well as UPPER CASE, lower case and sometimes Sentence case. But in OpenOffice there is no such option.
After a fair bit of trawling I found my answer and thought it would be useful to add them to my blog as a notebook entry for me and as a help for anyone else looking for a quick fix.

So if you use Open Office here are a couple of solutions:

Changing a field to Title Case in Open Office Calc (Excel Equivalent)
Click on the cell in the next empty column across from the field you want to change. key in =PROPER ( ) and insert the cell number that you want to change inside the brackets for example =PROPER(A1) You will now have the A1 cell repeated in B1 cell with the words in title case.

Changing a field to Title Case in Open Office Writer (Word Equivalent)
Select Format>Character and then click on the Font Effects tab and select Title from the Effects drop down list.