Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mround function equivalent that does not require "add-in" | Excel Discussion (Misc queries) | |||
Why are german users getting an error with Mround? ATP installed. | Excel Worksheet Functions | |||
Mround to nearest 5 c | Excel Discussion (Misc queries) | |||
MROUND function. Getting the following error: #NAME? | Excel Worksheet Functions | |||
MROUND function disappears | Excel Discussion (Misc queries) |