Nothing works in Excel. Excel will do what it wants.

But that doesn't stop the MS support and a thousand stupid people from claiming "oh, you just have to format it as text, are you dumb or what"...