Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem using newly created user function in Excel 2003 Richard Excel Discussion (Misc queries) 10 January 22nd 07 12:44 AM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
excel 2003 If function Stan Halls Excel Worksheet Functions 4 June 15th 06 08:42 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
CHR() function not working in Excel 2003 Richard Jonas Excel Discussion (Misc queries) 4 February 16th 05 08:45 AM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"