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.
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.