How can I alter the rounding rules?

Is it possible to alter the rounding rules in Excel so that it rounds up when
the value is .5 or higher

Excel already rounds up at 0.5

Under what circumstances are you experiencing different rounding behavior?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Greg" wrote:

> Is it possible to alter the rounding rules in Excel so that it rounds up when
> the value is .5 or higher

That's what it does

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Greg" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to alter the rounding rules in Excel so that it rounds up
> when
> the value is .5 or higher

Try these tips usinf custom functions

http://vertex42.com/ExcelTips/significant-figures.html

"Greg" > Is it possible to alter the rounding rules in Excel so that it
rounds up when
> the value is .5 or higher