2007/1/2, Alex Zachopoulos <[EMAIL PROTECTED]>:
I've formatted a column in a Calc .ods file to contain dates in DD/MM/ YYYY format. What happens, unfortunately, is that if I enter a date for up to the 12th of any month, Calc formats it as MM/DD/YYYY. Example: I want to enter June 13, 2007, so I type in the cell: "13/6/07" or even "13/6". Once I hit Enter, Calc displays "13/06/2007" in the cell. But if I want to enter June 12, 2007, and I type: "12/6/07" or "12/6", after I hit Enter, Calc displays "06/12/2007" in the cell. I also notice that regardless of the date in the cells of that particular column, when I select one of them, the date appears as MM/ DD/YYYY in the edit bar at the top (is that what you call it? the field just above the column headings, to the right of the Σ and = icons?) Why is that? How can I ensure that dates will definitely enter and display the way I stipulate? Many thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Dear Alex The date format OOo is putting into your column is the US one. I suppose that is the version of OOo you are using... I have the NL version (Dutch), and dates are put as you and I want them to be. Andf if I put in 12/31/06, OOo (rightly) thinks it isn't a date. Did you specify your country and language preferences under Tools > Options
Language settings > Language? This may solve your problem. If not, come
back to the list. A happy new year to you! -- Guy using english OOo 2.0.4 on a iMac Intel DualCore Tiger and dutch OOo 2.1 RC 1 on a G4 PPC Powerbook Tiger -- please reply only to [email protected] -- Dodoes can't afford to have headaches
