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?

What application are you talking about (Writer, Calc, Impres...)? And which language settings do you use? — sleske, Aug 25 '10 at 21:48

score 21 · Accepted Answer · edited Jun 02 '12 at 16:50

21

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.

edited Jun 02 '12 at 16:50

Community

1

answered Aug 25 '10 at 23:11

sleske

22,652
10
69
93

score 1 · Answer 2 · answered Aug 25 '10 at 23:07

1

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.....

answered Aug 25 '10 at 23:07

eslambasha

358
1
6

That's not really what was asked. The poster didn't ask how to insert a date in a certain format, but how to disable the autoformatting when typing it in. Your answer does not do this. – sleske Aug 25 '10 at 23:15
thats what i thought when i first read the topic but when i copied and pasted that date into a new writer file it wasnt changed by the auto-correction, also i typed some dates and saved the file and made a print preview and it didnt change so i thought maybe he means how to use another auto formating way than the pre-defined one – eslambasha Aug 25 '10 at 23:29

score 1 · Answer 3 · answered Jan 15 '12 at 09:06

1

For Openoffice Writer:

Change date autocorrect style

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

answered Jan 15 '12 at 09:06

anlim

11
1

score 0 · Answer 4 · edited May 28 '15 at 10:35

0

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.

edited May 28 '15 at 10:35

kenorb

24,736
27
129
199

answered Aug 01 '13 at 12:33

rajesh mahto

1

score 0 · Answer 5 · answered May 28 '15 at 09:37

0

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

answered May 28 '15 at 09:37

Vijeesh

11

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

5 Answers5