how to copy displayed value only?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell reference in formula string displays abbreviated value 2
Excel Stop Excel from displaying rounded values 4
Rounding value from millions to decimal places 6
how do i sum of decimal digit in absolute terms 3
Additions of Round Function and Minus Sign at Once 7
Rounding Existing Formulas/Values 1
Addition errors with Decimal Places 5
Display Part of the cell value 6

Back
Top