Hi Daniel

I like to have his old Excel 2002 version that do the translations<vbg

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Daniel.M" wrote in message
...

Well, I would say the only functions that did NOT translate in your
formula were
the ones belonging to the Analysis Toolpak (ATP). Which is exactly what
Ron
told you.

The ALS() got translated to IF()
the AFRONDEN.N.VEELVOUD() did NOT translate to MROUND()

This is a known Excel shortcoming.

Solutions:
==========
1. Have a name (Ctrl-F3) defining the langage (Lang="Dt" or "Eg" or
whatever) and have your formulas containing ATP functions wrapped-written
like
this : IF(Lang="Dt", dutch_formula, english_formula)
In this scenario, the name has to be set on the Workbook_Open event
using Application.International(xlCountryCode) result

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

3. Bypass ATP functions (either by using other 'normal' functions or VBA
code)
For instance, MROUND(A1,A2) can be replaced by =ROUND(A1/A2,)*A2

Regards,

Daniel M.

"MMS USA" <MMS wrote in message
...
Well, I would have to say they don't. Otherwise this would not be a
problem.

Is anyone else seeing this issue?

"Ron de Bruin" wrote:

Hi

All normal Excel functions will translate(also in 2003)
Only the ATP Add-in functions not.

For a file with translations see (FuncRefXLv4-0 from Norman Harker)
http://www.contextures.com/functions.html


--
Regards Ron de Bruin
http://www.rondebruin.nl



"MMS USA" <MMS wrote in message
...
Thank you, but this information is too sensitive to send. As you can
see,
If
is already used in the equations, not Als. These are Dutch words for
things
like sum, etc. that the US version is not recognzing.

I'm looking to understand what makes 2002 read these equations and
2003
not.

Are there language updates that may not be in the 2003 install?

"Ron de Bruin" wrote:

Hi MMS USA

If = Als in Dutch
You can send me the file private and I will test it for you



--
Regards Ron de Bruin
http://www.rondebruin.nl



"MMS USA" <MMS wrote in message
...
I've recently upgraded from the previous USA Office XP 2002 to USA
Office
XP
2003.

In office XP 2002 I was able to use our company's excel file that
comes
from
Holland. All the equations in the excel file are written in
Dutch.
Here's
an example:


=IF(+G21<"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+ 0.49,1),IF(+G21<1000,AFRONDEN.
N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.V EELVOUD(+G21+4.99,10),IF(+G21<
20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN. N.VEELVOUD(+G21+24.99,50))))),
"")

Now, in Office XP 2003 the contents of this equation produces
#NAME?.
I
can't seem to find any type of language setting or addon package
that
corrects this. Nor can I seem to find out what language changes
have
been
made between the two versions.

I've had multiple different installations of XP 2002 on different
computers
all able to "translate" these equations so that tells me it wasn't
unique
to
just 1 install. How do I get XP 2003 to recognize these
equations?

Any help would be greatly appreciated.