Bob <baasha <at> shaw.ca> writes: > > I have a column set up in Calc to format dates as MM/DD/YY. This > normally works fine. A couple of days ago I tried to enter two dates, > 09/12/05 (Sep. 12th) and 10/12/05 (Oct. 12th). The program seems to > assume that because I am entering this information in December, then I > must mean Dec. 9th and Dec. 10th, which is not the case. I can not seem > to find a way to override this behaviour. Am I doing something wrong, > or is this a bug? > I take it the dates are displaying as 12/09/05 and 12/10/05 even though you input 09/12/05 and 10/12/05. That is strange because the format DD/MM/YY would still show your input as entered. If your cell formats are still correct, perhaps you need to check language settings - Tools /Options /Language Settings /Languages.
You haven't used any other formatting? If you do not format the cells, the format you use seems to be the default format. Perhaps you should put the matter beyond any doubt by selecting English (USA) as the language when formatting the cells. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
