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.

=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_...usands/61.html using
Google search term "excel format thousands"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"professional student" <professional
wrote in message ...
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.