How do I use English function names in a Dutch Excel 2003?
 

I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

How do I use English function names in a Dutch Excel 2003?
 

Not possible with a Dutch version Casey.

You can install a MUI version of Office to switch between Dutch and English
http://www.microsoft.com/office/edit...ilability.mspx

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Casey" wrote in message ...
I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

How do I use English function names in a Dutch Excel 2003?
 

I don't think you should worry about this.

When the recipient opens the workbook, excel will "translate" the functions into
that recipient's language.

But you'll want to test it out.

There could be problems with some functions (maybe from the analysis
toolpak????).

And things like:
=INDIRECT("r1c1",FALSE)

In English versions R1C1 will mean Row 1, Column 1 in R1C1 reference style.
Your Dutch version uses different letters for R(ow) and C(olumn).

===
Ron de Bruin has shared lots of workbooks with me (and lots of users). Maybe
he'll chime in--or one of the non-English users.

Casey wrote:

I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

--

Dave Peterson

How do I use English function names in a Dutch Excel 2003?
 

Ron,

I read the OP's question slightly differently.

Can you think of any function that won't get translated when an English excel
user opens a workbook that you created (in de Bruin-ish <vbg)?

Ron de Bruin wrote:

Not possible with a Dutch version Casey.

You can install a MUI version of Office to switch between Dutch and English
http://www.microsoft.com/office/edit...ilability.mspx

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Casey" wrote in message ...
I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

--

Dave Peterson

How do I use English function names in a Dutch Excel 2003?
 

Hi Dave

my English organizer (HP Ipaq),
I think this is the problem ???
That's why I say No

For the OP
In a normal Excel version the functions translate to the English or Dutch
For the ATP functions see
http://www.rondebruin.nl/atptranslator.htm




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
I don't think you should worry about this.

When the recipient opens the workbook, excel will "translate" the functions into
that recipient's language.

But you'll want to test it out.

There could be problems with some functions (maybe from the analysis
toolpak????).

And things like:
=INDIRECT("r1c1",FALSE)

In English versions R1C1 will mean Row 1, Column 1 in R1C1 reference style.
Your Dutch version uses different letters for R(ow) and C(olumn).

===
Ron de Bruin has shared lots of workbooks with me (and lots of users). Maybe
he'll chime in--or one of the non-English users.

Casey wrote:

I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

--

Dave Peterson

How do I use English function names in a Dutch Excel 2003?
 

See my reply in your answer Dave

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
Ron,

I read the OP's question slightly differently.

Can you think of any function that won't get translated when an English excel
user opens a workbook that you created (in de Bruin-ish <vbg)?

Ron de Bruin wrote:

Not possible with a Dutch version Casey.

You can install a MUI version of Office to switch between Dutch and English
http://www.microsoft.com/office/edit...ilability.mspx

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Casey" wrote in message ...
I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

--

Dave Peterson

How do I use English function names in a Dutch Excel 2003?
 

Thank you for your reponses so far. I trust that Excel sheets will be
transportible between different installed languages, but that was not the
question. Exporting my Excel sheet to Pocket Excel on my HP wont't do the
trick. Sorry to hear it won't work. Kind of oversight, to put it mildly.

"Casey" wrote:

I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

How do I use English function names in a Dutch Excel 2003?
 

Thanks for the link (from someone who has trouble with his plain old English
version).

Ahhh. The iPAQ is a handheld pocket pc.

I have no idea, but wouldn't the .xls file that's opened with the iPAQ just get
translated like any other .xls file?

Ron de Bruin wrote:

Hi Dave

my English organizer (HP Ipaq),
I think this is the problem ???
That's why I say No

For the OP
In a normal Excel version the functions translate to the English or Dutch
For the ATP functions see
http://www.rondebruin.nl/atptranslator.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
I don't think you should worry about this.

When the recipient opens the workbook, excel will "translate" the functions into
that recipient's language.

But you'll want to test it out.

There could be problems with some functions (maybe from the analysis
toolpak????).

And things like:
=INDIRECT("r1c1",FALSE)

In English versions R1C1 will mean Row 1, Column 1 in R1C1 reference style.
Your Dutch version uses different letters for R(ow) and C(olumn).

===
Ron de Bruin has shared lots of workbooks with me (and lots of users). Maybe
he'll chime in--or one of the non-English users.

Casey wrote:

I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

--

Dave Peterson

--

Dave Peterson

How do I use English function names in a Dutch Excel 2003?
 

From Casey's reply, it sounds like the answer is no.

Dave Peterson wrote:

Thanks for the link (from someone who has trouble with his plain old English
version).

Ahhh. The iPAQ is a handheld pocket pc.

I have no idea, but wouldn't the .xls file that's opened with the iPAQ just get
translated like any other .xls file?

Ron de Bruin wrote:

Hi Dave

my English organizer (HP Ipaq),
I think this is the problem ???
That's why I say No

For the OP
In a normal Excel version the functions translate to the English or Dutch
For the ATP functions see
http://www.rondebruin.nl/atptranslator.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
I don't think you should worry about this.

When the recipient opens the workbook, excel will "translate" the functions into
that recipient's language.

But you'll want to test it out.

There could be problems with some functions (maybe from the analysis
toolpak????).

And things like:
=INDIRECT("r1c1",FALSE)

In English versions R1C1 will mean Row 1, Column 1 in R1C1 reference style.
Your Dutch version uses different letters for R(ow) and C(olumn).

===
Ron de Bruin has shared lots of workbooks with me (and lots of users). Maybe
he'll chime in--or one of the non-English users.

Casey wrote:

I have a Dutch Excel 2003 running. If I make a new sheet, the system forces
me to use Dutch function names. Since I want to be able to transfer my sheets
to my English organizer (HP Ipaq), I need the regular English function names.
SUM in stead of SOM, ROUND in stead of AFRONDEN etc. My Excel gives errors on
the English function names and I cannot find a switch or setting with wich
that can be done. I gather this problem will occur with any other language.
Please help me out.

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson