On 01/09/2009 04:59 AM, M Henri Day wrote: > 2009/1/9 Richard Detwiler <[email protected]> > >> Dotan Cohen wrote: >> >>> In OOo 2.4 I managed to disable automatic number to date conversion. I >>> cannot for the life of me find out how in OOo 3.0, and from searching >>> the web it seems that this cannot be done?!? >>> >>> I do _not_ want to create a default template. I want to configure Calc >>> so that I can open a document, enter "8.5" into a cell, and not have >>> it turned into a date or anything else. I repeat that for this use >>> case a new default template is _not_ the answer, and neither is >>> defining each cell as text. >>> >>> Thanks. >>> >>> >>> >> >> I'm a bit confused by the issue as described. When I open a new Calc file >> in OOo 3.0, with no special template or formatting, and enter "8.5", it does >> not get turned into a date, or anything else. It just goes in as 8.5. > > > If, using OOo 3.0.0 (OOO300m9, build 9358) I enter «8.5» (without quotation > marks) in cell A1in a Calc spreadsheet and then click in a different cell, > the A1 entry automatically changes to «09-08-05» (without quotation marks) ; > i e, the same sort of phenomenon mentioned by Dotan above.... > > Henri
It is, as Brian points out, a locale issue. If I (using "en_US.UTF-8") enter 8.5 in a cell, I get 8.5. However if I enter 8/5 in the cell, I get 08/05/09 - unless of course I set my locale to Dutch, and then I get 05/08/09. Now I go a step further: Format|Cells|Numbers|-Language|-Dutch(Netherlands) and I can enter 8.5 in the cell and it will return 05-08-09. If I set it back to English US and then reenter 8.5, the result that I get is 8.5. Note to Dotan: If I set the cell language to Hebrew, I get 8.5. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
