software

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


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

quot;star737quot; gt; wrote in message
...
gt;i multiply two columns the result is in decimal. when i decrease decimal
gt;the
gt; value become non decimal (means last digit is up one number). now i want
gt; to
gt; copy this displayed value in another cell without decimal, how i could do
gt; this?
gt;
gt; e.g. 23 x 10.5 =230.5 after round-up = 231 (this is displayed value).
gt; Now I want to copy '231' in another cell, without decimal, it must
gt; show '231'
gt; as real value.
gt;
gt; Please help me in this matter