Every time I try to enter a fraction in Microsoft Excel 2010, it gets converted to a date.
So for example: 5.6 becomes 2013.05.06, and 5,6 becomes 1900.01.05 14:24:00. I do not want to format the cells as numbers, because then I have to set the number of decimal places. Either my integers will have ,00 at the end, or my floats get truncated.
How can I stop this behavior? Preferably, I'd like to disable this for Excel as a whole, rather than just for individual spreadsheets?
Best Answer
Put
'
before your value in the cell