My copy of XL2003 works backwards from what you posted... if I paste
formatted text from Word directly into a cell, the formatting is retained,
but if I paste it into the Formula Bar, the formatting is lost.

--
Rick (MVP - Excel)


"Jim" wrote in message
...
If I paste formatted text from Word into a cell, the formatting is lost.
If
I paste formatted text into the formula bar, the formatting is kept.
Manipulating formatting characters in a cell seems to have similar results
(most formatting is lost). Is there a way to programmatically access the
formula bar of a cell to achieve a "true" text formatting?