How do I stop Open Office from automatically changing the date format?

Question

I am trying to enter a date in a document with the following format:

1 September 2010

However, OpenOffice insists on changing it to:

01/09/10

I've looked in the AutoCorrect options and elsewhere and have been unable to find a way to disable this annoying behaviour. Any suggestions?

Answer 1

This is a special auto-correct behaviour that is only active for tables in Writer (not in Calc). It is controlled under:

Tools > Options > OpenOffice.org Writer > Table > Input in tables > Number recognition

Uncheck that option to disable the autocorrection.

Answer 2

changing the date format is simple just follow these steps: in OpenOffice Writer go to Insert > Fields > Other > select Date from the first box > Date fixed from the second box > Choose the format that u want to use from the third box then Click Insert.

edit: you also can add more formats from the same window if u want by double clicking on Additional Formats.....

Answer 3

For Openoffice Writer:

Change date autocorrect style

1. Go to Table.
2. In Number Format Menu - change Language to English UK or whatever you need - choose date style you want in Format.

Answer 4

Just click right mouse button where you fill date and:

formatcell -> number -> date -> formatcode -> DD MMMM YY -> then click OK button.

Your date related problem should be solved.

Answer 5

You can start with an apostrophe to ensure that it is recognised as a text and hence doesn't autocomplete.