Posted to microsoft.public.excel.misc
|
|
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
|