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

C

Casey

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.
 
D

Dave Peterson

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.
 
D

Dave Peterson

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>)?
 
C

Casey

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.
 
D

Dave Peterson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top