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?