software

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; TextThis was found at
www.exceltip.com/st/Rounding_...usands/61.html using
Google search term quot;excel format thousandsquot;
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from emailquot;professional studentquot; lt;professional gt;
wrote in message ...
gt;I am doing a spreadsheet of financial information and need to nearest
gt; thousand - as in 10,000 would look like 10. I have columns of numbers
gt; that
gt; need to have the last 3 numbers truncated.