Errata....

"JoeU2004" wrote:
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.

Duh, what Gord wrote, namely the custom format

#,##0,

Note the comma at the end. I missed it when I read Gord's posting. Also,
no need to round to thousands first.


----- original message -----

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