I had to change Regional Options profile to English (US).
Now it works.

�ukasz

"Niek Otten" wrote:

ToolsOptionsInternational tab, check Use System separators

--
Kind regards,

Niek Otten

"Lukasz Szczepanski" <Lukasz wrote in message
...
|I have similar problem (I must use ";"), but in regional options I have comma
| set up as list separator.
| Does it make sense?
|
| Lukasz
|
| "Harlan Grove" wrote:
|
| JohanS wrote...
| ....
| Functions are normally entered as =if(a210,"True","False")
| My excel is not accepting formulas typed in this format, but rather shows me
| the following when using the wizard: (not commas between arguments, but a
| single space) IF(logical_test value_if_true value_if_false)
| Even when using the wizard, it still returns error:
| The formula you typed contains an error (same if I enter commas)
|
| Somehow your PC's Windows List Separator character has become a space
| character. You need to revert it to a comma. Open your Control Panel
| (Start Menu Settings Control Panel), run the Regional Settings
| applet (it may be called Regional and Language Options). Under Windows
| XP, you'll need to click on the Customize... button in the Regional
| Options tab in the dialog. In older Windows versions there's a tab in
| the dialog for Number and Date formats. There's an entry for List
| separator. Change it to a comma.
|
|