| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert excel formulas from english to norwegian
I live in London, and I'm working on a english version of Excel and VBA.. I've just finished a massive workbook for my mother with standard english formulas, but it isn't recognised by her norwegian version on Excel and VBA. How can I convert this... is there a function library I can add to her version, so she can use my spreadsheets and macros? I have found one converter on the net, but it doesn't seem to work properly. Help would be much apprichiated, Thanks -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
Excel should automatically convert those formulae when the workbook is
opened in a Norwegian version. The exception is Analysis Toolpak functions, such as WEEKNUM, MROUND, etc., which don't translate automatically. It is best to rewrite these as non-ATP formulae. If you post your ATP formulae, we should be able to help you rewrite them. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ctech" wrote in message ... I live in London, and I'm working on a english version of Excel and VBA.. I've just finished a massive workbook for my mother with standard english formulas, but it isn't recognised by her norwegian version on Excel and VBA. How can I convert this... is there a function library I can add to her version, so she can use my spreadsheets and macros? I have found one converter on the net, but it doesn't seem to work properly. Help would be much apprichiated, Thanks -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
I would expect Excel to automatically convert the function/formualas too... however it does that seem to do this. Is there an option in Excel which can turn this on/off? I have Office XP on both the computers? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
I don't think so.
Give an example of an English function that doesn't translate in the Norwegian Excel. BTW, VBA works in English, regardless of the VBA version. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ctech" wrote in message ... I would expect Excel to automatically convert the function/formualas too... however it does that seem to do this. Is there an option in Excel which can turn this on/off? I have Office XP on both the computers? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
Non of the formulas I use gets converted.. Here is some examples: ISNUMBER SUMIF IF AVERAGE SUMPRODUCT i.e. =SUMPRODUCT(--(Inntekter!$B$5:$B$203=$B197), --(TEXT(Inntekter!$A$5:$A$203,"yyyymm")=""&K$9&""), --(Inntekter!$C$5:$C$203=$B$193), (Inntekter!$E$5:$E$203)) -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
So If I opens a excel document with norwegian formulas on my PC, should it thenautomatically update when I open it for the first time? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
Should do, doesn't it?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ctech" wrote in message ... So If I opens a excel document with norwegian formulas on my PC, should it thenautomatically update when I open it for the first time? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
For ATP function translations see
http://www.rondebruin.com/atptranslator.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Bob Phillips" wrote in message ... Should do, doesn't it? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ctech" wrote in message ... So If I opens a excel document with norwegian formulas on my PC, should it thenautomatically update when I open it for the first time? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
I'm now on an english PC with an english Excel Workbook, with english fomulas such as SUMIF, SUMPRODUCT etc... I want to convert all these Formulas to Norwegian formulas... By using: For ATP function translations see http://www.rondebruin.com/atptranslator.htm Nothing happens, when choosing Norwgian... why is this? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
You can not change the formulas to Norwegian formulas in a English version
If you have a MUI Office version you can switch to Norwegian http://www.microsoft.com/office/edit...e/default.mspx The Add-in will change the ATP functions When you use Weeknum for example in a English version and open it in a Norwegian version the formula give you a error. The add-in can change it to Norwegian formula for you then -- Regards Ron de Bruin http://www.rondebruin.nl "Ctech" wrote in message ... I'm now on an english PC with an english Excel Workbook, with english fomulas such as SUMIF, SUMPRODUCT etc... I want to convert all these Formulas to Norwegian formulas... By using: For ATP function translations see http://www.rondebruin.com/atptranslator.htm Nothing happens, when choosing Norwgian... why is this? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
His problem seems to be with non-ATP formulae Ron, which is weird.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ron de Bruin" wrote in message ... You can not change the formulas to Norwegian formulas in a English version If you have a MUI Office version you can switch to Norwegian http://www.microsoft.com/office/edit...e/default.mspx The Add-in will change the ATP functions When you use Weeknum for example in a English version and open it in a Norwegian version the formula give you a error. The add-in can change it to Norwegian formula for you then -- Regards Ron de Bruin http://www.rondebruin.nl "Ctech" wrote in message ... I'm now on an english PC with an english Excel Workbook, with english fomulas such as SUMIF, SUMPRODUCT etc... I want to convert all these Formulas to Norwegian formulas... By using: For ATP function translations see http://www.rondebruin.com/atptranslator.htm Nothing happens, when choosing Norwgian... why is this? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert excel formulas from english to norwegian
Hi Bob
What the OP want is not possible as I understand him correct "Use Norwegian formulas in a English version" I'm now on an english PC with an english Excel Workbook, with english fomulas such as SUMIF, SUMPRODUCT etc... I want to convert all these Formulas to Norwegian formulas... -- Regards Ron de Bruin http://www.rondebruin.nl "Bob Phillips" wrote in message ... His problem seems to be with non-ATP formulae Ron, which is weird. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ron de Bruin" wrote in message ... You can not change the formulas to Norwegian formulas in a English version If you have a MUI Office version you can switch to Norwegian http://www.microsoft.com/office/edit...e/default.mspx The Add-in will change the ATP functions When you use Weeknum for example in a English version and open it in a Norwegian version the formula give you a error. The add-in can change it to Norwegian formula for you then -- Regards Ron de Bruin http://www.rondebruin.nl "Ctech" wrote in message ... I'm now on an english PC with an english Excel Workbook, with english fomulas such as SUMIF, SUMPRODUCT etc... I want to convert all these Formulas to Norwegian formulas... By using: For ATP function translations see http://www.rondebruin.com/atptranslator.htm Nothing happens, when choosing Norwgian... why is this? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=514363 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert arabic numbers to english text format in excel? | Excel Worksheet Functions | |||
| Using english and non-English Excel commands simultaneously in anon-English installation | Excel Worksheet Functions | |||
| Norwegian stocks into Excel | Excel Discussion (Misc queries) | |||
| How can I convert Arabic numbers to English text format in EXCEL | Excel Discussion (Misc queries) | |||
| writting excel formulas in english in spanish version of office. | Excel Programming | |||
![Ctech[_97_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
