convert excel formulas from english to norwegian

**Ctech** · 02-20-2006, 07:44 AM

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

Bob Phillips · 02-20-2006, 08:00 AM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

**Ctech** · 02-20-2006, 08:19 AM

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?

Bob Phillips · 02-20-2006, 08:50 AM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

**Ctech** · 02-20-2006, 09:46 AM

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** · 02-20-2006, 12:34 PM

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?

Bob Phillips · 02-20-2006, 01:35 PM

Should do, doesn't it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ctech" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Ron de Bruin · 02-20-2006, 02:45 PM

For ATP function translations see
http://www.rondebruin.com/atptranslator.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Bob Phillips" <[email protected]> wrote in message news:%[email protected]...
> Should do, doesn't it?
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Ctech" <[email protected]> wrote in
> message news:[email protected]...
>>
>> 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
>>
>
>

**Ctech** · 02-20-2006, 04:13 PM

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?

Ron de Bruin · 02-20-2006, 04:50 PM

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

Bob Phillips · 02-20-2006, 08:00 PM

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
message
> news:[email protected]...
> >
> > 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
> >
>
>

Ron de Bruin · 02-21-2006, 12:55 PM

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" <[email protected]> wrote in message news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in
> message
>> news:[email protected]...
>> >
>> > 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
>> >
>>
>>
>
>