[SOLVED] formula code language


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

New Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 4th May 2017, 09:17
willemeulen's Avatar
willemeulen willemeulen is offline
Frequent User
MS Office Version: Office 2010 (work) 2016 personal devices.
MS Office Skill Level: OK at Excel, mediocre Word and limited experience in Project
 
Join Date: May 2009
Location: Johannesburg, South Africa
Posts: 172
Posts Per Day: 0.06
My Top Tip Count: 1
Thanks to others: 22
Thanked 0 Times in 0 Posts
Reputation: 0 (0) willemeulen is an unknown quantity at this point
1 Top Tips
South_Africa
Smile formula code language
     Excel: General   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: General   

Hi,

Over the years I taught myself (with help of forums) a fair amount of excel. So I'm completely used to the English formula code (index, if, sum etc.). Since I'm about to move back home I switched my office 365 to Dutch.

With the menu's It's quite doable but with the formula code its a frustration, that said it would be good to get used to it so I can help future colleagues which use the Dutch excel.

So i have the following question

Can I leave excel on Dutch but make the formula bar recognize both Dutch and English formula codes so I can get used to it?


Thanks
__________________
Willem van der Meulen BSc Soil & Water Eng (Netherlands)

The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!

  #2  
Old 4th May 2017, 09:40
snb's Avatar
snb snb is offline
Forum VIP
MS Office Version: > Office 97
MS Office Skill Level: Interested
 
Join Date: Feb 2011
Location: Europe
Posts: 1,393
Posts Per Day: 0.58
My Top Tip Count: 0
Thanks to others: 0
Thanked 314 Times in 307 Posts
Reputation: 5076 (70) snb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond reputesnb has a reputation beyond repute
Default Re: formula code language

------ Register to get rid of these "In Post" ads! ------


In VBA you can always use your English glossary.
I fear in the Excel's UI you can't, unless you build a macro in workbook_change.

  #3  
Old 4th May 2017, 10:15
Pete_UK's Avatar
Pete_UK Pete_UK is offline
Solution Centre Professional
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient with Excel
 
Join Date: Mar 2009
Location: Warrington, England
Age: 65
Posts: 640
Posts Per Day: 0.21
My Top Tip Count: 0
Thanks to others: 8
Thanked 135 Times in 134 Posts
Reputation: 2624 (41) Pete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond repute
Great_Britain
Default Re: formula code language

------ Register to get rid of these "In Post" ads! ------


If you are using the Dutch language version, then apart from using the Dutch translations of any keywords, you will also have to use semicolons ( ; ) as the list separator rather than commas ( , ) in any formulae.

Hope this helps.

Pete

The Code Cage Advertisment
Advertisement
  #4  
Old 4th May 2017, 14:59
willemeulen's Avatar
willemeulen willemeulen is offline
Frequent User
MS Office Version: Office 2010 (work) 2016 personal devices.
MS Office Skill Level: OK at Excel, mediocre Word and limited experience in Project
 
Join Date: May 2009
Location: Johannesburg, South Africa
Posts: 172
Posts Per Day: 0.06
My Top Tip Count: 1
Thanks to others: 22
Thanked 0 Times in 0 Posts
Reputation: 0 (0) willemeulen is an unknown quantity at this point
1 Top Tips
South_Africa
Default Re: formula code language

------ Register to get rid of these "In Post" ads! ------


Hi Pete,

Yes I notice the semicolons as well but that is not a biggie.....will get used to it.

It's more the formula's names that I have an issue with, the formula names are completely different and it does not recognize the English ones anymore, the one which comes to mind for example is IF formulas are now ALS..... it is maybe somewhat logical but wouldn't mind if they could recognize both formula names (dutch and english).

Then all the above said I wonder if the guys not stick to the English since about all forums are in English and use the ",".

Any advice from dutch forum users?

------------------------------ posted after 16 minutes of original post ------------------------------

What I can see I should stick to the English (American) version as it will save me a lot of frustration and the forums still work 1 on 1. If really needs be I can translate it on this page when helping a colleague or just tell them to send the file to me.

Link for translation site

http://dolf.trieschnigg.nl/excel/index.php
W
__________________
Willem van der Meulen BSc Soil & Water Eng (Netherlands)


Last edited by willemeulen; 4th May 2017 at 14:59.
  #5  
Old 7th May 2017, 02:47
LisaGreen's Avatar
LisaGreen LisaGreen is offline
Solution Centre Professional
MS Office Version: MS Office 97, 2003, 2007,2010
MS Office Skill Level: Can use VBA
 
Join Date: Jun 2011
Location: Houten, Nederlands
Age: 65
Posts: 568
Posts Per Day: 0.25
My Top Tip Count: 1
Thanks to others: 9
Thanked 18 Times in 16 Posts
Reputation: 270 (14) LisaGreen is a jewel in the roughLisaGreen is a jewel in the roughLisaGreen is a jewel in the rough
1 Top Tips
Great_Britain
Default Re: formula code language

------ Register to get rid of these "In Post" ads! ------


Hi willemeulen....

I'm pretty sure you can load up a dutch and an English version of excel on the same machine... If anyone knows if this is correct or not please chip in!

The formulas should alter automatically as you load workbooks into them. That should give you a good guide I think.


HTH
Lisa

  #6  
Old 8th May 2017, 08:37
maninweb's Avatar
maninweb maninweb is offline
Solution Centre Professional
MS Office Version: MS Office 2010 - 2016
MS Office Skill Level: Microsoft Excel MVP 2011 - 2016
 
Join Date: May 2011
Location: Aachen, Germany
Posts: 77
Posts Per Day: 0.03
My Top Tip Count: 0
Thanks to others: 3
Thanked 10 Times in 9 Posts
Reputation: 160 (8) maninweb has a spectacular aura aboutmaninweb has a spectacular aura about
Germany
Default Re: formula code language

------ Register to get rid of these "In Post" ads! ------


Hi willemeulen,

additionally, for translating formulas from English to Dutch, or vice-versa, or for any other language,
you can also use my Excel-Translator here: https://en.excel-translator.de/translator/

This forum has an integrated version of this translator too; you can reach it by clicking on the "Formula
Language Convertor" button. The newest formula parser is however only on the original site.

MS Office also offers Language Packs (they are free starting from Office 2016). You can then switch
from one language to another, including the UI. But you can not run e.g. 2 Excel instances in different
languages at the same time. Changing the Office language needs a restart of Office.

Best,
Mourad

The Code Cage Advertisment
Advertisement
  #7  
Old 8th May 2017, 10:58
willemeulen's Avatar
willemeulen willemeulen is offline
Frequent User
MS Office Version: Office 2010 (work) 2016 personal devices.
MS Office Skill Level: OK at Excel, mediocre Word and limited experience in Project
 
Join Date: May 2009
Location: Johannesburg, South Africa
Posts: 172
Posts Per Day: 0.06
My Top Tip Count: 1
Thanks to others: 22
Thanked 0 Times in 0 Posts
Reputation: 0 (0) willemeulen is an unknown quantity at this point
1 Top Tips
South_Africa
Default Re: formula code language

------ Register to get rid of these "In Post" ads! ------


Hi Mourad,

Thanks. You confirmed what I feared.

Switching a language in excel would it affect all office applications?

W
__________________
Willem van der Meulen BSc Soil & Water Eng (Netherlands)

  #8  
Old 8th May 2017, 11:32
maninweb's Avatar
maninweb maninweb is offline
Solution Centre Professional
MS Office Version: MS Office 2010 - 2016
MS Office Skill Level: Microsoft Excel MVP 2011 - 2016
 
Join Date: May 2011
Location: Aachen, Germany
Posts: 77
Posts Per Day: 0.03
My Top Tip Count: 0
Thanks to others: 3
Thanked 10 Times in 9 Posts
Reputation: 160 (8) maninweb has a spectacular aura aboutmaninweb has a spectacular aura about
Germany
Default Re: formula code language

------ Register to get rid of these "In Post" ads! ------


Hi willemeulen,

Yes, changing the language affects all Office Apps. And currently, there is no way in Excel to display for
example the formulas in Englisch and the UI in Dutch. Can be a little bit complicated, but that's how proceed,
if I need both Excel e.g. in German and English:

Way 1: using a virtual machine, e.g. VM Ware Player, where I install English (or more languages) and
then I can see both Excel on my screen(s).

Way 2: having e.g. Excel 2010 MSI (!) and Excel 2016 (C2R) installed and their language packs, so I
can switch 2016 to English and 2010 to German. Works for most formulas, excepted the new ones.

Way 3: Having Windows with LP's (e.g. DE and EN) installed, Office with LP's installed, create two users
and set for each one a different language in Windows & Office and using the switch user feature in Windows.
Mostly only useful for testing.

Best,
Mourad

  #9  
Old 9th May 2017, 09:44
willemeulen's Avatar
willemeulen willemeulen is offline
Frequent User
MS Office Version: Office 2010 (work) 2016 personal devices.
MS Office Skill Level: OK at Excel, mediocre Word and limited experience in Project
 
Join Date: May 2009
Location: Johannesburg, South Africa
Posts: 172
Posts Per Day: 0.06
My Top Tip Count: 1
Thanks to others: 22
Thanked 0 Times in 0 Posts
Reputation: 0 (0) willemeulen is an unknown quantity at this point
1 Top Tips
South_Africa
Default Re: formula code language

------ Register to get rid of these "In Post" ads! ------


Thanks Mourad,

Can see you walked the path already. Tanks a lot for you solutions, will see what works best for me.

For now I will leave it in English as I find the Dutch formula's out of my comfort zone. Understand the Dutch formula's but to type from scratch is a mission, they are all hard coded in my brain in the English code. In addition the English support is more expansive throughout the internet.

Willem
__________________
Willem van der Meulen BSc Soil & Water Eng (Netherlands)

The Code Cage Advertisment
Advertisement
New Reply
The Code Cage at Facebookhe Code Cage at Twitter


Tags
code, formula, language

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 08:21.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University
X vBulletin 3.8.7 Debug Information
  • Page Generation 0.20088 seconds
  • Memory Usage 6,600KB
  • Queries Executed 15 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footerEnd
  • (1)ad_footerStart
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_headerEnd
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_leftcolumn_code
  • (1)ad_navbar_below
  • (4)ad_postbit_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (9)helpful_answers
  • (1)helpfulanswers_javascript
  • (1)navbar
  • (3)navbar_link
  • (2)navbar_noticebit
  • (41)option
  • (9)post_thanks_box
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_ctoptip
  • (9)postbit_onlinestatus
  • (33)postbit_reputation
  • (9)postbit_wrapper
  • (1)showthread_changepostsowner_link
  • (1)showthread_extra_fields
  • (1)showthread_quickreply_mrgdp
  • (1)showthread_reason_popup
  • (1)spacer_close
  • (1)spacer_open
  • (1)su_form
  • (3)tagbit
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_datastore.php
  • ./includes/class_hook.php
  • ./awcoding/plugins/awc.php
  • ./awcoding/plugins/ds.php
  • ./awcoding/plugins/ss.php
  • ./includes/functions_notice.php
  • ./mobiquo/smartbanner.php
  • ./mobiquo/include/classTTConnection.php
  • ./mobiquo/smartbanner/head.inc.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/vbatags.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php
  • ./includes/functions_misc.php 

Hooks Called:
  • init_startup
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_check_criteria
  • notices_noticebit
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • helpfulanswers_showthreadorpost
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • helpfulanswers_show_normal
  • reputation_power
  • reputation_image
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • error_fetch
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete