I use English Win7 with English Excel 2010, but Hungarian locale (we have decimal comma). Evey time I try to enter a fraction, it gets converted to a date. 5.6 becomes 2013.05.06, and 5,6 becomes 1900.01.05 14:24:00. How can I stop this behavior? I do not want to format the cells as numbers, because than I have to set the number of decimal places. Either my integers will have ,00 at the end, or my floats get truncated.
Why does it happen anyway? If I need a date, I enter a date. Do not convert anything! How can I turn this off, preferably for excel as a whole, not just for individual spreadsheets?