Format Cells, select the Number tab and choose the Custom category. In the
text box, enter #,##0,
That trailing ',' drops three digits (likewise ,, would give you millions).

"Barb" wrote:

How can I show whole numbers rounded to thousands by dropping the zeros?

Ex. 1,234,567 to show as 1,234