how to copy displayed value only?

[Guest]

i multiply two columns the result is in decimal. when i decrease decimal the
value become non decimal (means last digit is up one number). now i want to
copy this displayed value in another cell without decimal, how i could do
this?

e.g. 23 x 10.5 =230.5 after round-up = 231 (this is displayed value).
Now I want to copy '231' in another cell, without decimal, it must
show '231'
as real value.

Please help me in this matter

 

[Bill Kuunders]

one way

in stead of formatting the result to show no decimals you should
use a formula to show the rounded value.
=round(C1,0)

you can copy -- paste special --value-- to copy the value anywhere