| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
National language function names
Hi All,
Does an English language Excel2003 recognize a function written in a national language? E.g. in a workbook produced by a Hungarian language version contains =SZORZATĂ–SSZEG(...), which is =SUMPRODUCT(...)'s equivalent. Shall it be transformed to =SUMPRODUCT(...) when opened in an English language version? Thanks, Stefi |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
National language function names
Yes. Not the old Analysis Toolpak functions, though.
There may be problems with constants, like FormatStrings in the TEXT function and R1C1 style addresses in the INDIRECT() function, and probably more. With Excel2007 there is another issue with ATP functions; look he http://www.rondebruin.nl/atp.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Stefi" wrote in message ... Hi All, Does an English language Excel2003 recognize a function written in a national language? E.g. in a workbook produced by a Hungarian language version contains =SZORZATĂ–SSZEG(...), which is =SUMPRODUCT(...)'s equivalent. Shall it be transformed to =SUMPRODUCT(...) when opened in an English language version? Thanks, Stefi |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
National language function names
Thanks Niek, fortunately - for the moment - I need only basic functions!
Stefi €žNiek Otten€ť ezt Ă*rta: Yes. Not the old Analysis Toolpak functions, though. There may be problems with constants, like FormatStrings in the TEXT function and R1C1 style addresses in the INDIRECT() function, and probably more. With Excel2007 there is another issue with ATP functions; look he http://www.rondebruin.nl/atp.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Stefi" wrote in message ... Hi All, Does an English language Excel2003 recognize a function written in a national language? E.g. in a workbook produced by a Hungarian language version contains =SZORZATĂ–SSZEG(...), which is =SUMPRODUCT(...)'s equivalent. Shall it be transformed to =SUMPRODUCT(...) when opened in an English language version? Thanks, Stefi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function language | New Users to Excel | |||
| date format code in national language version | Excel Discussion (Misc queries) | |||
| How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
| Add-in function - language | Excel Worksheet Functions | |||
| language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
Linear Mode
