| Home |
| Search |
| Today's Posts |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Round funciton to handful of numbers
Hello Jamie,
Maybe Sub addround2() Dim cell As Range For Each cell In Selection If Not cell.HasFormula And IsNumeric(cell) Then cell = "=ROUND(" & cell.Text & ",-2)" End If Next cell End Sub You have raw data and you do not want to change any formula (or apply this macro repeatedly), I guess. Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding a round function to an existing formula | Excel Worksheet Functions | |||
| round numbers in the millions to numbers in the thousands | Excel Worksheet Functions | |||
| How do you round off numbers 5,518,943 to 5,520,000 | Excel Discussion (Misc queries) | |||
| Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) | |||
| Why does Excell round-off figures when adding them? | Excel Discussion (Misc queries) | |||
Threaded Mode
