If I select a cell, and copy, it goes to the clipboard differently than if I
select the text from the formula bar. (I know, formatting gets included).
My problem is, I have an external application that can not paste unless it is
in the format of a copied cell !!!

So, how can I convert a text only entry on the clipboard to one that looks like
it was copied as a cell?

I'd like to do this in VB.