Rounding: How do I round to '000s?

Excel Help for Rounding: How Do I Round To '000s? in Analyzing Corporate Financial Data

Rounding: How Do I Round To '000s?

Rate this: (3/5 from 6 votes)

	We're preparing financial statements for our board.  They only want to see values expressed in terms of thousands of dollars.  Ergo, instead of showing "10,000", they only want to see "10".  How do I do this in excel? Your help is greatly appreciated!
	Posted by msurdan on 06 Dec 2007

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Copy and Paste Special 1000 Rate this: (3/5 from 6 votes) You could try copying a cell with 1,000 in it and then paste special on your data with a divide to divide all the data by 1,000.
	Excel Business Forums Administrator
	Posted by Excel Helper on 06 Dec 2007

Displaying page 1 of 1