Round to Thousands

Henry G. · Feb 19th, 2002, 08:50 AM

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 · Feb 19th, 2002, 08:59 AM

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

good luck

Ed Acosta · Feb 19th, 2002, 10:43 AM

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. · Feb 19th, 2002, 01:28 PM

Thanks,
All of the above work well.

Henry G.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 08:50 AM	#1
Henry G. New Member Join Date: Feb 2002 Location: Louisiana U.S.A. Posts: 30	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?

Feb 19th, 2002, 08:59 AM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	I think you'll need to round first =ROUND(A1,-3) then apply a custom format such as #,###, good luck

Feb 19th, 2002, 10:43 AM	#3
Ed Acosta Board Regular Join Date: Feb 2002 Location: Bushkill, PA Posts: 54	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.

Feb 19th, 2002, 01:28 PM	#4
Henry G. New Member Join Date: Feb 2002 Location: Louisiana U.S.A. Posts: 30	Thanks, All of the above work well. Henry G.