Hi Garry,

Your formulas will be translated automatically; Excel stores formulas in an
"international" format, and displays them according to the language
version. Same is true for Reference styles (A1 or R1C1), decimal delimiters,
thousand separators, etc.
However, it is not true for add-ins, including Analysis Toolpak. Those
function calls will not be translated automatically. Refer to Eric Desart's
site to find a translation guide.
Also, there can be problems with functions using literals (between quotes),
like the format string in the TEXT function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Garry Jones" wrote in message
...
I have an xls that I have written with Swedish Excel 97.

I have used things like IF, COUNTIF and OR.

However, in Swedish Excel

IF is OM
COUNTIF is ANTAL.OM
OR is ELLER

Will this code work if I send to to England to be used on Excel 97. Or
will I have to first do a "search and replace" and change all the code.
What about the decimal point? - the Swedish Windows/Excel uses a decimal
comma.

If this is not going to work without altering are there any tools/addins
that will do this for me?

There are a also few bits of simple VB program code in it. From what I
can see these are in English so I presume that these will be okay. Or?

Garry Jones