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 changeright click sheet tabview codecopy\paste my
macroput cursor somewhere in the macro textF5if all is well,SAVE

--
Don Guillett
SalesAid Software

"Martina" wrote in message
...
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.

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

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