Try
Format Cells Number Custom
In the "Type" box enter #,##0,

This chanes the format while keeping the precision of the number of future
calculations.

"Dave F" wrote:

Assuming the value is in A1, then =LEFT(ROUND(A1,0),3) would return the
thousands value.
--
Brevity is the soul of wit.


"Round 123,456 to read 123" wrote:

Hi need help fast....
I need to round my number to the nearest thouseand.
Example 123,456.7890
I want it to read 123
I formatted to the deimal is rounded but can't round the comma....
I tried the custom cell formatting options...No Luck
HELP