How do you round to nearest thousand? ie 10,000 to 10

  • Thread starter professional student
  • Start date
P

professional student

I am doing a spreadsheet of financial information and need to nearest
thousand - as in 10,000 would look like 10. I have columns of numbers that
need to have the last 3 numbers truncated.
 
B

Bernard Liengme

=ROUND(A1,-3) does the rounding

But you just want formatting:
1. Press Ctrl+1 to open the Format Cells dialog box.
2. Select the Number tab, and from Category, select Custom.
3. In the Type box, enter the following Custom Formatting syntax:
#,##0, ;[Red](#,##0,);- ;
Result:
.. Original number: 5,645,625
.. The displaying formatted number: 5,646
Note:
The number formatting syntax is:
Positive; Negative; 0; Text


This was found at
http://www.exceltip.com/st/Rounding_Numbers_to_Thousands/61.html using
Google search term "excel format thousands"
best wishes
 
Top