Quik way to eliminate decimals

[huorsa]

Does anybody know a quick way to eliminate decimals, I mean I have 245.89 and I want to convert it to 246, and if I have 298.34 I want to convert it to 298.

I don't want to have 246.00 I just want 246

 

[phantom1975]

You could format the cells as NUMBER with 0 decimal places.

 

[huorsa]

That doesn't work because it just hides the decimals, because if I press F2 I see the number with the decimals.

I want to convert from 56.98 to 57 and 56.49 to 56. If I press F2 I want to see 57 not 56.98

 

[Aladin Akyurek]

If you want to do it literally...

=TRUNC(A1)

Edit. Upon re-reading your post, it's just:

=ROUND(A1,0)

which, I suppose, needs no exhibit.

 

[Yogi Anand]

That doesn't work because it just hides the decimals, because if I press F2 I see the number with the decimals.

I want to convert from 56.98 to 57 and 56.49 to 56. If I press F2 I want to see 57 not 56.98

Try the ROUND function ...

y040302h1.xls
	A	B	C	D
3		56.98	57
4		56.49	56
Sheet14