Round to Thousands

[Henry G.]

I am trying to format a whole column to round each cell’s contents to the nearest thousand. EXAMPLE: 5,132,982 would read 5,133 and 3,312,013 would read 3,312 etc. I do not want to divide each number by 1000. Is there a way to highlight the whole column and perform some customized formatting that will give the intended result?

 

[IML]

I think you'll need to round first
=ROUND(A1,-3)
then apply a custom format such as
#,###,

good luck

 

[Ed Acosta]

You can type 1000 in an empty cell, copy it, highlight the column or the cells you want to adjust. Do paste special and select the divide button. Then format it to drop decimal and you are done.

 

[Henry G.]

Thanks,
All of the above work well.

Henry G.