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?