"Marissa" wrote:
Is there a way to round a number and than drop to only show
a portion of it. For example: 567,549 to appear as 568.

If you have 567,549 in one cell (A1) and you want 568 in another cell, you
can do:

=round(A1/1000,0)

Similarly, if you have a formula in a cell (A1) and you want to change the
formula so that it displays only thousands:

=round((formula)/1000,0)

The parentheses around "formula" may or may not be needed, depending on the
formula.

But if you want the cell value to remain 567,549 and only appear as 568, I
believe you need a formatting option to do that, and I am not aware of any
that does.