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. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת ا-ب-ت-ث-ج-ح-خ-د-ذ-ر-ز-س-ش-ص-ض-ط-ظ-ع-غ-ف-ق-ك-ل-م-ن-ه-و-ي А-Б-В-Г-Д-Е-Ё-Ж-З-И-Й-К-Л-М-Н-О-П-Р-С-Т-У-Ф-Х-Ц-Ч-Ш-Щ-Ъ-Ы-Ь-Э-Ю-Я а-б-в-г-д-е-ё-ж-з-и-й-к-л-м-н-о-п-р-с-т-у-ф-х-ц-ч-ш-щ-ъ-ы-ь-э-ю-я ä-ö-ü-ß-Ä-Ö-Ü
