Solved: Converting excel functions from English to French

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Kate0n

Thread Starter
Joined
Sep 26, 2011
Messages
3
Hello,

I have tried seaching for this information, but I can't find it anywhere.
What I would like to know is, do function words in Excel convert automatically if sent to someone with Excel in another language.
For example:

I am user English version of Excel. In my spreadsheet I use "COUNT" funtion. If I then send this document to someone who has the French version of Excel does "COUNT" then become "COMPTE" (which is the French equivalent).

Thanks in advance
 

Kate0n

Thread Starter
Joined
Sep 26, 2011
Messages
3
I'm not sure if this would make a difference, but the versions of Excel are both 2007.
 
Joined
Jul 28, 2006
Messages
1,223
The answer is yes. Functions, default date format, and separators of arguments all change according to language.

Jimmy
 

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
First Name
Hans
Hi Kate,
Yes, if you mail an Excel sheet with the French names of the functions in the sheet itsself, they will automatically be translated when it's opend in another language like Dutch or German.

The only time you get into a serious problem is when you record a macro using a Function and then let somebody use this same macro in another language setting the Macro which in your case would be:

Active.cell.Formula="=COMPTE(A1:A4)"

will result as an error if the language is English since the correct synatx would be =COUNT(A1:A4)

The same the other way around.

Normal expressions in the sheet itsself no problem.

I have attached a file I found while searching for similar issues because we use Dutch versions

The sheet contains macros which you should allow, and if you double click on the first row on French then the english and the French column and all but the english and French column will be hidden so that you can see the equivalent English function for the French one and vice vversa.

Double click on Englsih and all columns will be visible again.
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top