1
I'm getting a strange error in Excel where I cannot enter formulas:
=ROUND(1.5,0)
gives an error:
The formula you typed contains an error
I presume it has something to do with the (red herring) fact that I am in a locale that uses:
.
for decimal point,
for digit grouping,,
for list separation
How do I enter these formulas in Excel?
Update: semi-colon doesn't work:
1Can you try
=ROUND(1.5;0)
? – Mehper C. Palavuzlar – 2011-09-09T15:19:52.397Try Alt+0132, because that looks like a single character, not two commas. – Excellll – 2011-09-09T15:22:08.667
@Mepher C. Palavuzlar: That doesn't work: "The formula you typed contains an error" – Ian Boyd – 2011-09-09T15:32:13.067
@Excelll: You can't use Alt+keypad codes in Excel; it interprets keypad strokes as navigation, and trues to leave the cell – Ian Boyd – 2011-09-09T15:32:57.073
@Ian Boyd: Keypad codes work just fine in Excel. Maybe you don't have NumLock on? – Excellll – 2011-09-09T17:33:11.537