Internationalization for formulas & macros

[mictou]

Hi Frank,

Unfortunately, simple functions such as "=SUM(A1:A4)" are not working
The resulting cell get's an error.
However, if I manually change "=(SUM(A1:A4)" to it's french equivalen
"=SOMME(A1:A4)", I get the right value.

Is there a setup or parameter in Excel to set, so Excel can interpre
english formulas (or macros) in french. Same for french to english.

Thank'

 

[Frank Kabel]

Hi
never heard of this issue. This is not an old Excel 95 file?

 

[Niek Otten]

Hi Mictou,

What error do you get?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel