copy number with 3 or more decimal places and paste the actual value as 2 decimal number

use the round function
in B1
=ROUND(A1,2)

then you can do the copy paste value in itself(B1) if thats what the "Actual value" means.

something like

Please Login or Register  to view this content.

Originally Posted by humdingaling

actual value would mean the number displayed in 2 decimal places as opposed to rounded valued

in that case to format this way
CTRL + 1
Select Number> 2 decimal places

Actually that just changes the appearance or display of the value, not the value stored in the "register" or "stack". The rounding functions actually change the stored value.

Prove it to yourself. Place the same three-or-more-decimal-place values in two cells. Change the Number format as you suggest to one of the cells. Now in adjacent cells, multiply each value by pi and set dispayed decimal places to three or greater. The results will be identical no matter how many decimal places are displayed. That means setting the Number format to lesser decimal places only changes the appearance, not the stack value.