Can I Change the language of an excel formula

[Guest]

I have a dutch version of excel. Now I'm learning to program. I've bought
Excel 2003 Power programming with VBA (John Walkenbach). In the instructions
in the book he uses formulas (sum(a1:a15) from the english version. However
in the Dutch version the formula is Som(a1:a15). Does anyone know if I there
is a way so that I can use the english formulas in my Dutchg version of Excel.

 

[Peo Sjoblom]

No, you can't use English functions although a workbook made on an English
Excel will translate when opened on a Dutch one

http://cherbe.free.fr/traduc_fonctions_xl97.html

above are some translations and a countryman of yours (keepitcool) have made
this splendid add-in
that I strongly recommend

http://members.ams.chello.nl/keepitcool/download.html



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Ken Wright]

As Peo said, it should translate when an English file is opened in your version,
so make full use of the example files John provides on the CD that accompanies
the book.

 

[Anders Silven]

Hi Jan,

One way is to use the Immediate Window in the Visual Basic Editor, I find it
most useful to translate formulas between Swedish and English and v/v.

For example, try
Range("A2").Formula = "=SUM(A1:A15)" [Enter]
in the Immediate Window and
=SOM((A1:A15)
will be entered in cell A2.

You can do it the other way too, try
?Range("A2").Formula [Enter]
and you will get
=SUM(A1:A15)

This technique also takes care of different argument separators
(commas/semicolons), try
range("A3").Formula = "=SUM(1,2,3)" [Enter]
which will result in
=SOM(1;2;3)
assuming the Dutch separator is the semicolon.

Quotes in a formula must be doubled like in
Range("A4").Formula = "=""A""&""B""" [Enter]
which will give the formula
="A"&"B"

HTH
Anders Silven