Sometimes when I’m working with an Excel worksheet and I want a cell to look a certain way, I run into what appears to be a limitation in the program. It might be trying to enter product numbers with ...
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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results