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

[Guest]

How do I round to the nearest thousand without individually having to do it
for every cell?

 

[Frank Kabel]

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

 

[Don Guillett]

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

 

[Guest]

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.

 

[Don Guillett]

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