Excel Formulas not in English

Copper Contributor

Hi, the default language in my settings is English; yet all my Eformulas are in French. I would like to work only with EN formulas, what should I do?

3 Replies

@lucile1050 

If Display Language is set as English you shall have formulas in English

image.png

 

Hi @Sergei Baklan,

 

Yes actually, you are right. My formulas are in English, but for instance, I use this one to get which days are the dates of my planning: =TEXT(Q12;"ddd")

 

And the result displayed is ddd

If I change it to =TEXT(Q12;"jjj") for Jour/Day in French, the day appear but in French...

@lucile1050 

My guess that's since you have French locale on you computer.