Cell Translation from German to English

robkiolbasa

New Member
Joined
Mar 18, 2011
Messages
1
Hello,

I am having a problem with a workbook that was created in a German version of excel, and is being opened with an English version of excel.

The specific cell that is causing the problems is coded as:
=CELL("Adresse",KF!AD5)
My expectation is that excel would translate this cell to:
=CELL("Address",KF!AD5)

If I manually change the german word "Adresse" to the english word "Address", it will work as expected. The problem with the manual translation is that when the German colleague tries to make updates, he will run into the same problem. We needs to to translate automatically when excel is opened. All other functions seem to translate as expected. Any suggestions on how to get this cell to translate properly?

Excel version is 2003, SP3 (11.8328.8329) , also the office proofing tools are installed with the German dictionaries.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
As I understand it, if the English string for the info type is used, it will work in all languages, for example:

=ZELLE("address",a1)

in Dutch.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top