Funtions: For non-english Excel users

[Benzadeus]

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:
[VBA]Sub TranslateFormula()
ActiveCell.Formula = ActiveCell.Value
End Sub[/VBA]

Hope you enjoy it.

[Bob Phillips]

An easier way in VBA is

[vba]

Activecell.Formula = "=SUM(A1:A3,C1:C3)"
[/vba]

then check your spreadsheet.

[Benzadeus]

Yes, I agree!

[MaximS]

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]

xld,

I found it yearsterday: Using
[vba]Activecell.Formula = "=SUM(A1:A3,C1:C3)" [/vba]
is okay, but in
[vba]Activecell.Formula = "=A1 & " oranges""[/vba]
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.