WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I round to the nearest thousand without individually having to do it
for every cell?
 
Hi
if you want to do this for many cells you'll have to use VBA. Another
option: In a helper cell enter
=ROUND(A1,-3)
and copy for all rows
 
Pls don't type in all caps.

Sub roundto1000()
For Each c In Selection
c.Value = Round(c / 1000, 0) * 1000
Next c
End Sub
 
What is a VBA? Doing it in a helper cell means you have to do it for every
cell in the range. I als need to decrease the cell value more i.e. instead
of having 47,000 I need 47.
 
Give us your range (a2:c400)??? and then my macro can be modified to work
for you. You would then copy into a module and execute to change all. The
easiest, for you, would be to:

highlight the cells to change>right click sheet tab>view code>copy\paste my
macro>put cursor somewhere in the macro text>F5>if all is well,SAVE
 
Back
Top