It's because Excel thinks it knows what you want: so that even when you ask for something specific, it gives you what it thinks you want, not what you asked for.

This seems to suit accountants 😀