Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I apply a formula to #s already typed in a series of cells
I have a spreadsheet where I already have several hundred numbers typed in as
whole numbers. Is there a way to apply a formula to the whole section that will round each of the pre-typed numbers to the nearest thousand. I know how to do it using =ROUND on a cell by cell basis, but that would take me forever. Please help! |
#2
|
|||
|
|||
one way
Sub placformulaetoround() For Each c In Range("a2:a" & Cells(Rows.Count, "a").End(xlUp).Row) c.Value = Round(c / 1000, 0) * 1000 Next c End Sub -- Don Guillett SalesAid Software "redinBR" wrote in message ... I have a spreadsheet where I already have several hundred numbers typed in as whole numbers. Is there a way to apply a formula to the whole section that will round each of the pre-typed numbers to the nearest thousand. I know how to do it using =ROUND on a cell by cell basis, but that would take me forever. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |