Home

Excel Formulas not in English

%3CLINGO-SUB%20id%3D%22lingo-sub-862935%22%20slang%3D%22en-US%22%3EExcel%20Formulas%20not%20in%20English%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862935%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20the%20default%20language%20in%20my%20settings%20is%20English%3B%20yet%20all%20my%20Eformulas%20are%20in%20French.%20I%20would%20like%20to%20work%20only%20with%20EN%20formulas%2C%20what%20should%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-862935%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-862969%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20not%20in%20English%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862969%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411742%22%20target%3D%22_blank%22%3E%40lucile1050%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20Display%20Language%20is%20set%20as%20English%20you%20shall%20have%20formulas%20in%20English%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20575px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132574iDD055F6EEED816A1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863074%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20not%20in%20English%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863074%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20actually%2C%20you%20are%20right.%20My%20formulas%20are%20in%20English%2C%20but%20for%20instance%2C%20I%20use%20this%20one%20to%20get%20which%20days%20are%20the%20dates%20of%20my%20planning%3A%26nbsp%3B%3CFONT%3E%3DTEXT(Q12%3B%22ddd%22)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20the%20result%20displayed%20is%20ddd%3C%2FP%3E%3CP%3EIf%20I%20change%20it%20to%26nbsp%3B%3CFONT%3E%3DTEXT(Q12%3B%22jjj%22)%20for%20Jour%2FDay%20in%20French%2C%20the%20day%20appear%20but%20in%20French...%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863294%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20not%20in%20English%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863294%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411742%22%20target%3D%22_blank%22%3E%40lucile1050%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMy%20guess%20that's%20since%20you%20have%20French%20locale%20on%20you%20computer.%3C%2FP%3E%3C%2FLINGO-BODY%3E
lucile1050
New 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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies