Rounding and dropping digits

[Marissa]

Hello,

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. Thank you.

 

[Jacob Skaria]

A1 = 567,549
=ROUND(A1,0)

If this post helps click Yes

 

[Gord Dibben]

=ROUND(A1,-3)

Custom format to #,##0,


Gord Dibben MS Excel MVP

 

[Marissa]

Thank you but it did not work. The result was the number in A1.

 

[JoeU2004]

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.

 

[JoeU2004]

Errata....

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 -----

 

[Jacob Skaria]

Marissa Sorry. Initially I read this as 567.549 instead of comma....

Gord has answered this..Cheers


If this post helps click Yes