Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change "interface" language?
Hi,
I'm using the Swedish version of MS Excel (2003), and I just realized that it does not understand english names for the functions (such as #IF, #SUM etc), instead I have to write them in Swedish. Well, this is really annoying since I'm learning Excel formulas from an english book and each time I want to test the book examples I have to figure out the swedish "function names". So, my question: Is it possible to change the current language (Swedish) to English (so that I can use english function names)? Cheers, Mikael |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change "interface" language?
Hi Mikael,
I don't think so, but you can trick it to find out. If you go into the VB IDE (Alt-F11), and open the Immediate Window (Ctrl-G), and in there type say Activecell.Formula = "=SUM(A1,B3,C10)" and then go back to Excel and voila (or whatever the Swedish is), you will see the Swedish equivalent. Not thet my formula includes commas. You have to do this in VBA even if you use semi-colons in your Excel. Here are a few to get you started ABS ABS AND OCH AVERAGE MEDEL CEILING RUNDA.UPP CELL CELL CHAR TECKENKOD CHOOSE VÄLJ COLUMN KOLUMN COLUMNS KOLUMNER COUNT ANTAL COUNTA ANTALV COUNTBLANK ANTAL.TOMMA COUNTIF ANTAL.OM DATE DATUM DATEDIF DATEDIF DATESTRING DATESTRING DATEVALUE DATUMVÄRDE DAY DAG EVEN JÄMN EXACT EXAKT EXP EXP FACT FAKULTET FALSE FALSKT FIND HITTA FLOOR RUNDA.NER FREQUENCY FREKVENS HLOOKUP LETAKOLUMN HOUR TIMME IF OM INDEX INDEX INDIRECT INDIREKT ISERR ÄRF ISERROR ÄRFEL ISEVEN ÄRJÄMN ISNUMBER ÄRTAL ISODD ÄRUDDA LARGE STÖRSTA LEFT VÄNSTER LEN LÄNGD LOOKUP LETAUPP LOWER GEMENER MATCH PASSA MAX MAX MID EXTEXT MIN MIN MINUTE MINUT MOD REST MONTH MÅNAD NA SAKNAS NETWORKDAYS NETTOARBETSDAGAR NOMINAL NOMRÄNTA NOT ICKE NOW NU ODD UDDA OFFSET FÖRSKJUTNING OR ELLER PROPER INITIAL RAND SLUMP RANDBETWEEN SLUMP.MELLAN RANK RANG REPLACE ERSÄTT RIGHT HÖGER ROUNDDOWN AVRUNDA.NEDÅT ROUNDUP AVRUNDA.UPPÅT ROW RAD ROWS RADER SEARCH SÖK SECOND SEKUND SMALL MINSTA SUBSTITUTE BYT.UT SUBTOTAL DELSUMMA SUM SUMMA SUMIF SUMMA.OM SUMPRODUCT PRODUKTSUMMA TEXT TEXT TIME KLOCKSLAG TIMEVALUE TIDVÄRDE TODAY IDAG TRIM RENSA TRUE SANT UPPER VERSALER VALUE TEXTNUM VLOOKUP LETARAD WEEKDAY VECKODAG WEEKNUM VECKONR WORKDAY ARBETSDAGAR YEAR ÅR -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nisse" wrote in message ... Hi, I'm using the Swedish version of MS Excel (2003), and I just realized that it does not understand english names for the functions (such as #IF, #SUM etc), instead I have to write them in Swedish. Well, this is really annoying since I'm learning Excel formulas from an english book and each time I want to test the book examples I have to figure out the swedish "function names". So, my question: Is it possible to change the current language (Swedish) to English (so that I can use english function names)? Cheers, Mikael |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change "interface" language?
Hi Bob,
Thanks for your help. It works fine but it's quite time consuming (although I'll probably end up learning the translations as I go by). However, I'm leaning towards the possibility to exchange the swedish version for an english version. Question is: Do I have to purchase the English version or is there a LANGUAGE PACK that I can download (and presumably use to change interface language)? Kindly, Mikael "Bob Phillips" skrev i meddelandet ... Hi Mikael, I don't think so, but you can trick it to find out. If you go into the VB IDE (Alt-F11), and open the Immediate Window (Ctrl-G), and in there type say Activecell.Formula = "=SUM(A1,B3,C10)" and then go back to Excel and voila (or whatever the Swedish is), you will see the Swedish equivalent. Not thet my formula includes commas. You have to do this in VBA even if you use semi-colons in your Excel. Here are a few to get you started ABS ABS AND OCH AVERAGE MEDEL CEILING RUNDA.UPP CELL CELL CHAR TECKENKOD CHOOSE VÄLJ COLUMN KOLUMN COLUMNS KOLUMNER COUNT ANTAL COUNTA ANTALV COUNTBLANK ANTAL.TOMMA COUNTIF ANTAL.OM DATE DATUM DATEDIF DATEDIF DATESTRING DATESTRING DATEVALUE DATUMVÄRDE DAY DAG EVEN JÄMN EXACT EXAKT EXP EXP FACT FAKULTET FALSE FALSKT FIND HITTA FLOOR RUNDA.NER FREQUENCY FREKVENS HLOOKUP LETAKOLUMN HOUR TIMME IF OM INDEX INDEX INDIRECT INDIREKT ISERR ÄRF ISERROR ÄRFEL ISEVEN ÄRJÄMN ISNUMBER ÄRTAL ISODD ÄRUDDA LARGE STÖRSTA LEFT VÄNSTER LEN LÄNGD LOOKUP LETAUPP LOWER GEMENER MATCH PASSA MAX MAX MID EXTEXT MIN MIN MINUTE MINUT MOD REST MONTH MÅNAD NA SAKNAS NETWORKDAYS NETTOARBETSDAGAR NOMINAL NOMRÄNTA NOT ICKE NOW NU ODD UDDA OFFSET FÖRSKJUTNING OR ELLER PROPER INITIAL RAND SLUMP RANDBETWEEN SLUMP.MELLAN RANK RANG REPLACE ERSÄTT RIGHT HÖGER ROUNDDOWN AVRUNDA.NEDÅT ROUNDUP AVRUNDA.UPPÅT ROW RAD ROWS RADER SEARCH SÖK SECOND SEKUND SMALL MINSTA SUBSTITUTE BYT.UT SUBTOTAL DELSUMMA SUM SUMMA SUMIF SUMMA.OM SUMPRODUCT PRODUKTSUMMA TEXT TEXT TIME KLOCKSLAG TIMEVALUE TIDVÄRDE TODAY IDAG TRIM RENSA TRUE SANT UPPER VERSALER VALUE TEXTNUM VLOOKUP LETARAD WEEKDAY VECKODAG WEEKNUM VECKONR WORKDAY ARBETSDAGAR YEAR ÅR -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nisse" wrote in message ... Hi, I'm using the Swedish version of MS Excel (2003), and I just realized that it does not understand english names for the functions (such as #IF, #SUM etc), instead I have to write them in Swedish. Well, this is really annoying since I'm learning Excel formulas from an english book and each time I want to test the book examples I have to figure out the swedish "function names". So, my question: Is it possible to change the current language (Swedish) to English (so that I can use english function names)? Cheers, Mikael |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change "interface" language?
There is an Office 2003 Editions Multilingual User Interface Pac
http://www.microsoft.com/office/edit...ilability.mspx But it seems it only comes with a couple of English language versionbs of Office. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nisse" wrote in message ... Hi Bob, Thanks for your help. It works fine but it's quite time consuming (although I'll probably end up learning the translations as I go by). However, I'm leaning towards the possibility to exchange the swedish version for an english version. Question is: Do I have to purchase the English version or is there a LANGUAGE PACK that I can download (and presumably use to change interface language)? Kindly, Mikael "Bob Phillips" skrev i meddelandet ... Hi Mikael, I don't think so, but you can trick it to find out. If you go into the VB IDE (Alt-F11), and open the Immediate Window (Ctrl-G), and in there type say Activecell.Formula = "=SUM(A1,B3,C10)" and then go back to Excel and voila (or whatever the Swedish is), you will see the Swedish equivalent. Not thet my formula includes commas. You have to do this in VBA even if you use semi-colons in your Excel. Here are a few to get you started ABS ABS AND OCH AVERAGE MEDEL CEILING RUNDA.UPP CELL CELL CHAR TECKENKOD CHOOSE VÄLJ COLUMN KOLUMN COLUMNS KOLUMNER COUNT ANTAL COUNTA ANTALV COUNTBLANK ANTAL.TOMMA COUNTIF ANTAL.OM DATE DATUM DATEDIF DATEDIF DATESTRING DATESTRING DATEVALUE DATUMVÄRDE DAY DAG EVEN JÄMN EXACT EXAKT EXP EXP FACT FAKULTET FALSE FALSKT FIND HITTA FLOOR RUNDA.NER FREQUENCY FREKVENS HLOOKUP LETAKOLUMN HOUR TIMME IF OM INDEX INDEX INDIRECT INDIREKT ISERR ÄRF ISERROR ÄRFEL ISEVEN ÄRJÄMN ISNUMBER ÄRTAL ISODD ÄRUDDA LARGE STÖRSTA LEFT VÄNSTER LEN LÄNGD LOOKUP LETAUPP LOWER GEMENER MATCH PASSA MAX MAX MID EXTEXT MIN MIN MINUTE MINUT MOD REST MONTH MÅNAD NA SAKNAS NETWORKDAYS NETTOARBETSDAGAR NOMINAL NOMRÄNTA NOT ICKE NOW NU ODD UDDA OFFSET FÖRSKJUTNING OR ELLER PROPER INITIAL RAND SLUMP RANDBETWEEN SLUMP.MELLAN RANK RANG REPLACE ERSÄTT RIGHT HÖGER ROUNDDOWN AVRUNDA.NEDÅT ROUNDUP AVRUNDA.UPPÅT ROW RAD ROWS RADER SEARCH SÖK SECOND SEKUND SMALL MINSTA SUBSTITUTE BYT.UT SUBTOTAL DELSUMMA SUM SUMMA SUMIF SUMMA.OM SUMPRODUCT PRODUKTSUMMA TEXT TEXT TIME KLOCKSLAG TIMEVALUE TIDVÄRDE TODAY IDAG TRIM RENSA TRUE SANT UPPER VERSALER VALUE TEXTNUM VLOOKUP LETARAD WEEKDAY VECKODAG WEEKNUM VECKONR WORKDAY ARBETSDAGAR YEAR ÅR -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nisse" wrote in message ... Hi, I'm using the Swedish version of MS Excel (2003), and I just realized that it does not understand english names for the functions (such as #IF, #SUM etc), instead I have to write them in Swedish. Well, this is really annoying since I'm learning Excel formulas from an english book and each time I want to test the book examples I have to figure out the swedish "function names". So, my question: Is it possible to change the current language (Swedish) to English (so that I can use english function names)? Cheers, Mikael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change FORMAT | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
how do I change the default language on office on-line- helper on. | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) |