How do I format cell to 0.25 resolution?
 

I would like to restrict a cell to a 0.25 resolution. (5.00, 5.25, 5.50,
5.75, 6.00, ...).

How do I format cell to 0.25 resolution?
 

Right Click on the Cell Format Cells select Number set the decimal
places to 2


"Bugman" wrote in message
...
I would like to restrict a cell to a 0.25 resolution. (5.00, 5.25, 5.50,
5.75, 6.00, ...).

How do I format cell to 0.25 resolution?
 

Maybe

=ROUND(A1/0.25,0)*0.25

Mike

"Bugman" wrote:

I would like to restrict a cell to a 0.25 resolution. (5.00, 5.25, 5.50,
5.75, 6.00, ...).

How do I format cell to 0.25 resolution?
 

=MROUND(A2,0.25)
--
David Biddulph

"Bugman" wrote in message
...
I would like to restrict a cell to a 0.25 resolution. (5.00, 5.25, 5.50,
5.75, 6.00, ...).