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
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies