software

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

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,
Fredquot;Lucky_guy2000quot; gt; wrote in message
...
gt; Is it possible to format cells to automatically round a number, for example:
gt;
gt; 1.37 to 1.25 or 1.38 to 1.50
gt;
gt; I have used the mround formula when work with two different cell, i.e.,
gt; in cell b2 I use this formula: =mround(a2,.25) and it works.
gt;
gt; However, I would like use the format page (cntl 1) to do it automatically in
gt; the cell I am working. Any help would be great. Thanks.
gt; Johnnie
Fred,
Thanks for the help. I thought that there probably was not a way, but you
never know until you ask the experts.
Johnnie

quot;Fred Smithquot; wrote:

gt; Format will not round to quarter points. It can only round to a specified
gt; decimal point. If you need to round to quarters, you're stuck with using Mround.
gt;
gt; --
gt; Regards,
gt; Fred
gt;
gt;
gt; quot;Lucky_guy2000quot; gt; wrote in message
gt; ...
gt; gt; Is it possible to format cells to automatically round a number, for example:
gt; gt;
gt; gt; 1.37 to 1.25 or 1.38 to 1.50
gt; gt;
gt; gt; I have used the mround formula when work with two different cell, i.e.,
gt; gt; in cell b2 I use this formula: =mround(a2,.25) and it works.
gt; gt;
gt; gt; However, I would like use the format page (cntl 1) to do it automatically in
gt; gt; the cell I am working. Any help would be great. Thanks.
gt; gt; Johnnie
gt;
gt;
gt;