Leo,

I tried to duplicate your issue. By doing so I went to Control
PanelRegional and Language Settings Changed from English to German.
It did change the , to ; as you said. When I saved the application, closed,
changed my settings back to English, the ; returned to , as it should. I
could not get the program to ignore the ;. Have you ensured that your
regional settings are set to where you want them?

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Leo Mazzi" wrote:

I was wandering if this is a bug (so it will be fixed) or a feature (so I can
expect the same behavior in the following versions)...

Excel uses in many cell formulas the regional settings list separator
character to separate between parameters (example for GB the list separator
is "," so an IF formula would look as: "=IF(bool, true, false)" but when you
change the country to DE then the separator is ";" and you have to use the
formula in the way: "=IF(bool; true; false)".

Now this would not be a problem if Excel would not use the DEFAULT regional
configuration so if any user customizes his regional settings to have a
different separator than the default - Excel (tested with Excel 2003)
currently ignores it - so for example: the user selected in GB the ";" as a
separator - but Excel still thinks that the separator is ",".

Is this a BUG or a feature? Does anyone know about this?