PDA

View Full Version : Funtions: For non-english Excel users



Benzadeus
04-27-2009, 01:22 PM
I know there's a Non English Help forum at VBAX, but since most users (that include non-native english people) use this forum, I felt posting this here would be helpful.

Just discovered some curiosity:
My Excel is in Portuguese (Brazil), so, the worksheet functions are written in Portuguese.

For example, in English, the formula:
=SUM(A1:A3,C1:C3)

is, in Portuguese:
=SOMA(A1:A3;C1:C3)

A lot of times when I paste some formula in english on my spreadsheet, I have to rewrite it and that is very annoying. An easy way to immediate "translate" the formula in local Excel language is:

1 - Write the foreign formula with an ' before it, like:
'=SUM(A1:A3,C1:C3)
in the destination cell.

2 - VBA code:
Sub TranslateFormula()
ActiveCell.Formula = ActiveCell.Value
End Sub

Hope you enjoy it.

Bob Phillips
04-27-2009, 03:43 PM
An easier way in VBA is



Activecell.Formula = "=SUM(A1:A3,C1:C3)"


then check your spreadsheet.

Benzadeus
04-28-2009, 02:21 AM
Yes, I agree!

MaximS
04-28-2009, 03:11 AM
Hmm ... I cannot immagine now learning again all the Excel functions in my native language (Polish) after moving to England few years ago and learning everything with english version.

Only solution for me would be using VBA for every formula :)

Benzadeus
08-06-2009, 09:46 AM
xld,

I found it yearsterday: Using
Activecell.Formula = "=SUM(A1:A3,C1:C3)"
is okay, but in
Activecell.Formula = "=A1 & " oranges""
it is necessary to duplicate the " sinal where appears the string.

Also, to translate a formula with #1, it is not necessary opening the VBE.