Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Robert Just go ahead and explain what you want. If we think we can help you, we will explain what type of fuction to use and and under whicg group to look for the fuction. Thiem -- Thiem ------------------------------------------------------------------------ Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474 View this thread: http://www.excelforum.com/showthread...hreadid=495444 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Hi Robert,
In Hungarian Excel we found a FUNCS.XLS file in folding C:\Program Files\Microsoft Office\Office11\1038 that contained the translation table of English and Hungarian function names. Have a try, perhaps there is a similar table also in the Swedish version. Regards, Stefi Robert57 ezt *rta: Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Robert,
If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in the immediate window (Ctrl-G), just type ?Activecell.Formula this will give you the English equivalent, as VBA works in English. -- HTH RP (remove nothere from the email address if mailing direct) "Robert57" wrote in message ... Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Bob Phillips Wrote: Robert, If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in the immediate window (Ctrl-G), just type ?Activecell.Formula this will give you the English equivalent, as VBA works in English. QUOTE] Tnx Bob It was an easy way to do it and I will use it in the future. Robert The Hungarian way was not working on my Swedish Excel. Tnx anyway. -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Hi Bob,
Is there a similar way in the opposite direction? E.g. if I receive a function tip from you in English, does XL have any feature that translate it into a national language? Stefi Bob Phillips ezt *rta: Robert, If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in the immediate window (Ctrl-G), just type ?Activecell.Formula this will give you the English equivalent, as VBA works in English. -- HTH RP (remove nothere from the email address if mailing direct) "Robert57" wrote in message ... Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
You can download a formula translator he
http://members.chello.nl/keepitcool/download.html -- Kind regards, Niek Otten "Robert57" wrote in message ... Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Thanks, Niek, it's a fine add-in, but for the moment it doesn't speak
Hungarian. Maybe it will be added in the future, as it's mentioned in the About-text! Regards, Stefi Niek Otten ezt *rta: You can download a formula translator he http://members.chello.nl/keepitcool/download.html -- Kind regards, Niek Otten "Robert57" wrote in message ... Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Yep.
In the immediate window: activecell.formula = "=yourformulahere" Remember to double up your quotation marks if have them: activecell.formula = "=if(a1="""","""",a1) And if you have the formula in R1C1 notation: activecell.formular1c1 = "=yourformulahere" (And make sure that the activecell is where you want it <vbg.) Stefi wrote: Hi Bob, Is there a similar way in the opposite direction? E.g. if I receive a function tip from you in English, does XL have any feature that translate it into a national language? Stefi Bob Phillips ezt *rta: Robert, If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in the immediate window (Ctrl-G), just type ?Activecell.Formula this will give you the English equivalent, as VBA works in English. -- HTH RP (remove nothere from the email address if mailing direct) "Robert57" wrote in message ... Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
But this does assume that you have that language version installed.
-- HTH RP (remove nothere from the email address if mailing direct) "Dave Peterson" wrote in message ... Yep. In the immediate window: activecell.formula = "=yourformulahere" Remember to double up your quotation marks if have them: activecell.formula = "=if(a1="""","""",a1) And if you have the formula in R1C1 notation: activecell.formular1c1 = "=yourformulahere" (And make sure that the activecell is where you want it <vbg.) Stefi wrote: Hi Bob, Is there a similar way in the opposite direction? E.g. if I receive a function tip from you in English, does XL have any feature that translate it into a national language? Stefi ?zBob Phillips? ezt *rta: Robert, If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in the immediate window (Ctrl-G), just type ?Activecell.Formula this will give you the English equivalent, as VBA works in English. -- HTH RP (remove nothere from the email address if mailing direct) "Robert57" wrote in message ... Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Language
Thanks Dave and Bob, that is the case, I run a Hungarian version, and this
translation method works nicely! Regards, Stefi Dave Peterson ezt *rta: Yep. In the immediate window: activecell.formula = "=yourformulahere" Remember to double up your quotation marks if have them: activecell.formula = "=if(a1="""","""",a1) And if you have the formula in R1C1 notation: activecell.formular1c1 = "=yourformulahere" (And make sure that the activecell is where you want it <vbg.) Stefi wrote: Hi Bob, Is there a similar way in the opposite direction? E.g. if I receive a function tip from you in English, does XL have any feature that translate it into a national language? Stefi âžBob Phillipsâ ezt Ã*rta: Robert, If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in the immediate window (Ctrl-G), just type ?Activecell.Formula this will give you the English equivalent, as VBA works in English. -- HTH RP (remove nothere from the email address if mailing direct) "Robert57" wrote in message ... Hi I'm new here and first problem is for me what to call a function in english. I'm running a swedish Excel so Do you have a translation table or something so I know what to write so you understand. Robert -- Robert57 ------------------------------------------------------------------------ Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838 View this thread: http://www.excelforum.com/showthread...hreadid=495444 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |