This is an extension of my previous post – Freeze a random result with mouse trick.
In my experience using Excel, from Excel 2000 to 2010, and recently 365 (I’d never used Excel 2013 though), I have experienced the same strange behavior when I tried to convert a random number to value by using copy and paste value – the random numbers got re-calculated before the paste action. It happened to me in different PC (work, school, or home). Therefore I thought it is a common problem until David N left his comments to my post.
It aroused my curiosity. I tried again with four different ways to paste (random) values to see if I get different results. Interestingly, it did. See below:
A) Using shortcut Ctrl+Alt+V to open the paste special dialog, then select Value. It works! 🙂
B) Using the mouse trick discussed in previous post. It works! 🙂
C) Using the “Paste”, “Values” under Home Tab. It doesn’t work. 😦
D) Using Right-Click, Paste Value. It doesn’t work. 😦
Tip: Using Clipboard also works! 🙂
Honestly I have no clues why it happened. If you know, please leave your comments.
Anyway, it reminds me one thing that I always say to my audience when I conduct in-house Excel training:
Always check your result! No matter how confident you are!