Cutting and pasting in Microsoft Office applications saves you untold hours in typing and retyping data and text. If you are like many business users of Microsoft Excel, you probably perform countless ...

It’s not easy to fool Excel, but with a few extra clicks, you can work around this odd pasting behavior. If you paste formatted values into a cell with another applied format, the pasted format wins.