Dear experts

Say i have entered a value of 20, but the number format is 5200..

the result is 520020.

How do i copy the final result to a different cell.. I tried paste and also paste specials.. nothing work..

Is there a way to copy number formatted cell along with entered values ?