UDF excel function

%3CLINGO-SUB%20id%3D%22lingo-sub-1844557%22%20slang%3D%22en-US%22%3EUDF%20excel%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1844557%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20is%20there%20someone%20who%20could%20tell%20me%20why%20in%20Excel%20formula%20list%20I%20have%20my%20UDF%20mixed%20with%20the%20foreign%20version%20of%20Excel%26nbsp%3B%20built%20in%20functions.%20As%20you%20can%20see%20excel%20is%20in%20French%20but%20my%20own%20UDF%20are%20mixed%20with%20Italian%20version%20of%20excel%20functions%2C%20I%20don't%20use%20Italian%2C%20further%20in%20the%20list%20there%20is%20norwegian%20version%20of%20excel%20functions%2C%20It%20is%20a%20mess%20to%20find%20out%20my%20own%20UDF.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dominique_Pardoncstb_0-1604326646015.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F230826iDCD9F30DD66D3B64%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dominique_Pardoncstb_0-1604326646015.png%22%20alt%3D%22Dominique_Pardoncstb_0-1604326646015.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1844557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1844676%22%20slang%3D%22de-DE%22%3ESubject%3A%20UDF%20excel%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1844676%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F854515%22%20target%3D%22_blank%22%3E%40Dominique_Pardoncstb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EChange%20language%20in%20Excel%20%3CBR%20%2F%3E%20Follow%20the%20step-by-step%20instruction.%3CBR%20%2F%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%20These%20instructions%20apply%20to%20Microsoft%20Office%20Excel%2C%20version%202010%20or%20later%20on%20Windows.%20%3CBR%20%2F%3E%3CSTRONG%3E1st%20step%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%20Open%20Excel%20and%20then%20switch%20to%20the%20%22File%22%20tab.%3CBR%20%2F%3EGo%20to%20%22Options%22%20at%20the%20bottom%20left.%20%3CBR%20%2F%3E%3CSTRONG%3E2nd%20step%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%20Then%20a%20new%20window%20will%20open.%20Click%20on%20%22Language%22%20in%20the%20ribbon%20on%20the%20left.%20In%20the%20%22Select%20editing%20language%22%20area%20you%20will%20see%20%22e.g.%20German%20(Germany)%22%20marked%20with%20%22%3CSTANDARD%20setting%3D%22%26quot%3B%26quot%3B%22%3E%22.%3C%2FSTANDARD%3E%20Click%20on%20your%20preferred%20language%20and%20then%20on%20the%20button%20%22Set%20as%20default%22.%3CBR%20%2F%3ENote%3A%20You%20can%20expand%20the%20range%20of%20languages%20using%20the%20%22Add%20additional%20editing%20languages%22%20drop-down%20menu.%20Make%20your%20selections%2C%20then%20click%20Add.%20%3CBR%20%2F%3E%3CSTRONG%3E3rd%20step%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%20In%20the%20lower%20area%20(%22Select%20display%20language%22)%20you%20can%20also%20change%20the%20display%20and%20help%20language.%20Simply%20click%20on%20the%20language%20and%20then%20on%20%22OK%22.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EThen%20restart%20Excel%20once.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello, is there someone who could tell me why in Excel formula list I have my UDF mixed with the foreign version of Excel  built in functions. As you can see excel is in French but my own UDF are mixed with Italian version of excel functions, I don't use Italian, further in the list there is norwegian version of excel functions, It is a mess to find out my own UDF.

 

Dominique_Pardoncstb_0-1604326646015.png

Regards

3 Replies
Highlighted

@Dominique_Pardoncstb 

Change language in Excel
Follow the step-by-step instruction.
Note: These instructions apply to Microsoft Office Excel, version 2010 or later on Windows.
1st step:
Open Excel and then switch to the "File" tab.
Go to "Options" at the bottom left.
2nd step:
Then a new window will open. Click on "Language" in the ribbon on the left. In the "Select editing language" area you will see "e.g. German (Germany)" marked with "<standard setting>". Click on your preferred language and then on the button "Set as default".
Note: You can expand the range of languages ​​using the "Add additional editing languages" drop-down menu. Make your selections, then click Add.
3rd step:
In the lower area ("Select display language") you can also change the display and help language. Simply click on the language and then on "OK".

Then restart Excel once.

 

Hope I was able to help you.

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here

 

 

 

Highlighted

@NikolinoThank you but it doesn't fix the problem, I have found a solution with unselect the Excel solver add on. What I have taken for foreign version of excel functions were the foreign version of Excel functions bound with the Excel solver. I ll try to manage it according what I need at the moment switching from select to unselect and vice versa solver add on.

Regards

Highlighted
Nice that you could find a solution yourself.
I wish you continued success with Excel :))

Nikolino
I know I don't know anything (Socrates)