Problem description: On entering date as d/m in cell formatted as date, cell does not show in expected format
Steps to reproduce:
1. Format cell as date (say) 31 Dec 99
2. Input date in form 20/8....
Current behavior:Cell remains showing 20/8
Expected behavior:20 Aug 12
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0.1
(In reply to comment #0)
Works for me. I followed the steps you listed and I got the exact date which I had specified in "Format Cellss".
Tested with: Version 22.214.171.124 (Build ID: 932b512)
Uninstalled ver 126.96.36.199, and installed 188.8.131.52. NO other changes made to computer, and the bug disappeared. therefore, it would appear to me to be in 184.108.40.206
Seems to be a duplicate of bug 52240
See Tools → Options → Language settings → Languages → Locale setting and Date acceptance patterns.
For Estonian (my language) the patterns are: D.M.Y;D.M;D. M;D.M.;D. M.
For English (USA) they are: M/D/Y;M/D
Enter your own version if these do not suit you. If your input does not match any of these, it is probably treated as text.
Feel free to reopen if this is not the case.