On 01/09/2009 10:55 AM, 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. >
Then I fail to see what the problem is & agree with Harold and Erling - use a comma. If you look at Tools|Options|Language Settings|Language|Decimal separator key will be set to a comma (,) when the locale setting is set to Dutch (Belgium). --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
