Rouding Decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
?
 
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
 
Back
Top