Pasting Values, Number Stored As Text

Hello,

When I am copying and pasting cell contents that are numbers (which represent SKUs) using the following CODE, it pastes them WITHOUT the green error shading in the corner that says "Number Stored As Text" and gives you the option to convert it. That is what most people want to happen.

I actually desire the opposite effect, I want the shading to appear and the little error icon to be available. Right now, I have to click into the cell and then click out in order for it to appear.

How would I do this?

Please Login or Register  to view this content.

Just format the cells as text before pasting.

Please Login or Register  to view this content.

Interesting, I found a way to do it by looping through the selection and just clicking every cell, but I'll have to give this a shot too!