Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem using newly created user function in Excel 2003 | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
excel 2003 If function | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) |