The Computer Oracle

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

--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Dream Voyager Looping

--

Chapters
00:00 How Do I Stop Open Office From Automatically Changing The Date Format?
00:27 Accepted Answer Score 22
00:49 Answer 2 Score 1
01:16 Answer 3 Score 1
01:36 Answer 4 Score 0
01:55 Answer 5 Score 0
02:06 Thank you

--

Full question
https://superuser.com/questions/180711/h...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#openoffice #openofficewriter

#avk47



ACCEPTED ANSWER

Score 22


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

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




ANSWER 3

Score 1


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

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




ANSWER 5

Score 0


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