View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default use excel sheet in a different language

Hi Forumsteiger,

I wonder what will happen, if a user in lets say the US will open that
file. That user will have an English version of Excel. Will this
English version be able to parse the German formula "wenn(
gleich(A1;A2) ; B2; F8 )"?
Or will I have to rewrite all formulas, i.e. replace any "wenn" by "if"
and any "gleich" by "equals" and so on?
If this replacement has to been done, is there a software which can do
this transformation automatically or will I have to do the changes
manually?


As long as you haven't used any functions from the analysis toolpak
addin, your safe, Excel will automatically translate all functions. ATP
functions will not be translated however. There is a translation utility
he

http://www.acoustics-noise.com/ATPtranslator.shtml

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com