That's how it works in Excel, I'm not sure how it works under the hood but it's translated to your system locale so you can open up your French speaking colleag

That's how it works in Excel, I'm not sure how it works under the hood but it's translated to your system locale so you can open up your French speaking colleagues spreadsheet and not notice the difference until they start asking about "=RECHERCHEV()".