Rouding Decimals

[Guest]

Hey guys.

Quick question, what formula, cause Floor or Ceiling or Round Up or Round
Down is not working can I use, that would take a number like 14.25 and bring
it to its nearest whole interger like 14, but if it was 14.51, would take it
to 15. And then that I could copy and paste that as a value, and the
decimals would not come out again?

Any ideas
?

 

[JulieD]

Hi

if i'm understanding you correctly just use
=ROUND(A1,0)

then copy it, choose edit / paste special and select values to get it so
that it is a number without the decimals.

Cheers
JulieD

 

[Frank Kabel]

Hi
=ROUND(A1,0)