Hi!

You can't use formatting in that manner but you could use a function.

=CEILING(A1,0.5)

Or, put your current formula inside:

=CEILING(SUM(A1:A10),0.5)

Biff

"daveb" wrote in message
...
I am trying to format a number cell so that the decimal value rounds up to
the next .5. Is this possible? I