| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spanish/English Formulas
I'm writing a code that inputs a formula in a cell.
How can I get it so the formula is readable either in English and Spanish versions of Excel?. i.e. '=SUM(A1,B1)' and '=SUMAR(A1;B1)', please note the different separations ',' and ';'. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Spanish/English Formulas
Hi econcult
If you insert it with VBA you can use the English formulas and seperator ActiveCell.Formula = "=SUM(A1,B1)" On a Spanish machine it will be =SUMAR(A1;B1) in the cell Only you can't use the ATP functions this way -- Regards Ron de Bruin http://www.rondebruin.nl "econcult" wrote in message ... I'm writing a code that inputs a formula in a cell. How can I get it so the formula is readable either in English and Spanish versions of Excel?. i.e. '=SUM(A1,B1)' and '=SUMAR(A1;B1)', please note the different separations ',' and ';'. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format dates from English to Spanish | Excel Worksheet Functions | |||
| How do I change a spreadsheet from English to Spanish? | Excel Discussion (Misc queries) | |||
| How do I Translate English-Spanish in Excel | Excel Discussion (Misc queries) | |||
| How do I change a spreadsheet from English to Spanish | New Users to Excel | |||
| how can I change the language from spanish to english? | Excel Programming | |||
Linear Mode
