MRound
 

Is it possible to format cells to automatically round a number, for example:

1.37 to 1.25 or 1.38 to 1.50

I have used the mround formula when work with two different cell, i.e.,
in cell b2 I use this formula: =mround(a2,.25) and it works.

However, I would like use the format page (cntl+1) to do it automatically in
the cell I am working. Any help would be great. Thanks.
Johnnie

MRound
 

Format will not round to quarter points. It can only round to a specified
decimal point. If you need to round to quarters, you're stuck with using Mround.

--
Regards,
Fred


"Lucky_guy2000" wrote in message
...
Is it possible to format cells to automatically round a number, for example:

1.37 to 1.25 or 1.38 to 1.50

I have used the mround formula when work with two different cell, i.e.,
in cell b2 I use this formula: =mround(a2,.25) and it works.

However, I would like use the format page (cntl+1) to do it automatically in
the cell I am working. Any help would be great. Thanks.
Johnnie

MRound
 

Fred,
Thanks for the help. I thought that there probably was not a way, but you
never know until you ask the experts.
Johnnie

"Fred Smith" wrote:

Format will not round to quarter points. It can only round to a specified
decimal point. If you need to round to quarters, you're stuck with using Mround.

--
Regards,
Fred


"Lucky_guy2000" wrote in message
...
Is it possible to format cells to automatically round a number, for example:

1.37 to 1.25 or 1.38 to 1.50

I have used the mround formula when work with two different cell, i.e.,
in cell b2 I use this formula: =mround(a2,.25) and it works.

However, I would like use the format page (cntl+1) to do it automatically in
the cell I am working. Any help would be great. Thanks.
Johnnie