If you want the text "1/2" you should type '1/2
If you want the value one-half you should type =1/2
Not sure why this is controversial, Excel obviously has a syntax that's not focused on reproducing literal text.
If you want the value one-half you should type =1/2
Not sure why this is controversial, Excel obviously has a syntax that's not focused on reproducing literal text.
That is desired behaviour. If you want the string 1/2 you need to use an apostrophe. If you want the fraction one half you need to use an equals sign. Both of these are vastly less likely to be what a user wants than the date interpretation, so it makes sense for that to be the default.