Remember Me?

#1
May 18th 05, 09:51 PM
 redinBR Posts: n/a
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.

#2
May 18th 05, 11:09 PM
 Don Guillett Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM Curious Excel Worksheet Functions 1 April 12th 05 09:49 PM momtoaj Excel Worksheet Functions 3 April 6th 05 04:06 PM stumpy1220 Excel Worksheet Functions 2 January 14th 05 05:11 PM

All times are GMT +1. The time now is 08:08 AM.