Use a format of #,##0

--
HTH

Bob Phillips

"teebee0831" wrote in message
...
Is there a way to round numbers up so that if I enter 45.999 in cell A1,
it
will display at 46 in the cell and in the formula bar?


I do not want the originally entered number to show any decimals.