On 09/01/2009 18:55, Dotan Cohen wrote:
2009/1/9 NoOp <[email protected]>:
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.
Actually, I am using a Dutch locale as I need the yyyy-mm-dd date
formating. I think that I will file yabtwbibs on the issue.
If I was using Dutch locale I'd expect to enter decimal points as
commas, not as dots. Try entering 8,5 instead of 8.5. I think it
*should* work.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
