Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheetfunctions,microsoft.public.excel.programming
|
|||
|
|||
I cant use englisch function names in a swedich version of excel
Hi,
Why can't I use Englisch named function names, like =ROUND(...) in a sheet when I have a Swedich version of excel. Excel will tell me the error "#Name?" when I open an Englisch version worksheet or if I try to enter an englisch function name. But if I write a macro with the englisch function name inside the code and I call that macro in the sheet the function will be translated to the swedich function name. Thanks Pelle |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheetfunctions,microsoft.public.excel.programming
|
|||
|
|||
I cant use englisch function names in a swedich version of excel
Hi
this is just the way Excel works. For a function translation see: http://www.contextures.com/functions.html -- Regards Frank Kabel Frankfurt, Germany PE wrote: Hi, Why can't I use Englisch named function names, like =ROUND(...) in a sheet when I have a Swedich version of excel. Excel will tell me the error "#Name?" when I open an Englisch version worksheet or if I try to enter an englisch function name. But if I write a macro with the englisch function name inside the code and I call that macro in the sheet the function will be translated to the swedich function name. Thanks Pelle |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheetfunctions,microsoft.public.excel.programming
|
|||
|
|||
I cant use englisch function names in a swedich version of excel
KeepItCool has a translation addin at:
http://members.chello.nl/keepitcool PE wrote: Hi, Why can't I use Englisch named function names, like =ROUND(...) in a sheet when I have a Swedich version of excel. Excel will tell me the error "#Name?" when I open an Englisch version worksheet or if I try to enter an englisch function name. But if I write a macro with the englisch function name inside the code and I call that macro in the sheet the function will be translated to the swedich function name. Thanks Pelle -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
version differences in excel 2007 - use of macros & range names | Excel Discussion (Misc queries) | |||
Sorting function in Excel 2003 lost in the 2007 version | Excel Worksheet Functions | |||
Recognition of crylic test in work sheet names, VB version 9108 | Excel Discussion (Misc queries) | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |