Home > Forum Home > Analyzing Corporate Financial Data > Rounding: How do I round to '000s? Share

Rounding: How do I round to '000s?

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


Forum TopicPost Reply Login

Rounding: How Do I Round To '000s?

Rate this:
(3/5 from 6 votes)
ConfusedWe'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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Rounding: How do I round to '000s? in the