Excel ROUND funtion doesn't work

[TanaseIonut]

Hello!

I want to use ROUND function in excel to display a number just with wo decimals.

Ex: 224.34567 to 224.34

If i use =ROUND(A2;2) it doesn't do anything. And my excel is showing me that the funtion is Round(number;numb_digits) and when i search on the internet everywhere is Round (number,numb_digits) just with comma,but if i use jut comma excel is showing me an error message.

 

[mjslakeridge]

That is odd. I have Office 2010 and =Round(A2,2) works fine for me. Are you sure A2 is the cell you are wanting to round?

 

[USAFRet]

Limit the format of the Cell to show only 2 decimals.

 

[USAFRet]

Office 2013 -
=ROUND(A1,2)

Works for me.

 

[Wolfshadw]

LIbreOffice Calc -
=Round(A1, 2)

Works for me.

Check your language settings.

-Wolf sends

 

[TanaseIonut]

https://s24.postimg.org/8vi93tqbp/Untitled_1.jpg

 

[Wolfshadw]

You've got two decimal points. It doesn't recognize cell A2 as a number.

-Wolf sends

 

[mjslakeridge]

Don't they use decimal points instead of commas in Europe? I could be wrong. Maybe a language setting in Office?

 

[USAFRet]

Don't they use decimal points instead of commas in Europe? I could be wrong. Maybe a language setting in Office?

Yes.
And if that is what his settings are (to use a dot instead of comma), there is nothing to ROUND in that 'number'.

 

[mjslakeridge]

Good point! But if I use the round function on a value with 2 numbers after the decimal point ($1,895.00), it doesn't throw and error, it just returns the same value, as it should.

 

[Wolfshadw]

What happens if you just enter 22434.567?

-Wolf sends

 

[TanaseIonut]

It was a mistake no matter if i type 234.567 or 234,567 it will show me the same and the ROUND function won't work.
If i use =ROUND(A2;2) it will show me the same number in both situations.
If i use =ROUND(A2,2) it will give me an ,,we have a problem with formula" error. Because as you saw in the image,even the excel told me that the round function is with ,, ; ". And i don't know why,because on microsoft page for excel help is with " , " ...

 

[USAFRet]

What is your language setting?

If you type 123,456...does it recognize that as a number?
Or 123.456

One Hundred and twenty three thousand.......

 

[TanaseIonut]

Is weird,i swear 5 minutes ago it wasn't working in any way, now it works if i use Ex: 234,567 ( with comma) and =ROUND(A2;2).
Is weird.