Open office calc

[aumentou]

In excel, if you set the date format of a cell to be DD/MM/YY, then when you type in, for example, 8-12 it assumes you put it in in the format you are using. So you get the eight of december. In open office it assumes you type your daes in like an american and ignores the formatting you have chosen, so you end up with the twelfth of august. Is there any way to fix this?

Comments

[beelze-bob.livejournal.com]

Yep, it involves a big hammer.

[astatine210.livejournal.com]

Tools->Options

Language Settings->Languages

Set the default language to English (UK).

[astatine210.livejournal.com]

That's my first guess, anyway. My version of OO seemed to use non-US dates straight off.

[grok-mctanys.livejournal.com]

The "date format" for a cell is probably the display format, which is not necessarily the input format. You might want to set the display format to "d mmmm, yyyy", but not want to have to type in all of "8 December, 2008" for it to be recognised properly.

Input format might be based on OOo settings (as described by Phil), or (more hopefully) based on your OS/desktop/shell language settings. What OS are you using? What language is it set to?