| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding range of cells
Does anyone know of a way to round a range of cells without doing it column
by column with the round function. For eg if all the numbers are in the format 150.30 (to 2 dp) and we would like to round each to 150 (0 d.p). Can a UDF etc be created to do this? If yes does anyone know how to do this? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells Rounding up but shouldn't be | Excel Discussion (Misc queries) | |||
| Move a value from one range to another - rounding occurs that I do not want....? | Excel Programming | |||
| Rounding a large range & a Missing Font | New Users to Excel | |||
| How to apply rounding across a range of cells with other formulae | Excel Worksheet Functions | |||
| Rounding Entries From Range to Array | Excel Programming | |||
Threaded Mode
