how to copy displayed value only?

[star737]

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

--
Greetings from New Zealand
Bill K

"star737" <star737@discussions.microsoft.com> wrote in message
news:BFA5B186-FDBA-4244-83FF-898B1831DCEB@microsoft.com...
>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