my "guess" is the formatting in a CELL in Excel is not IN the cell, not in the text. If you export as XML, you may see the "style" sections are defined and referenced within the cell.
or the Clipboard is not preserving the formatting (although on my Mac, I can see the formatting in Clipboard).
Pasting from Word, OTOH, does seem to bring along the formatting with the text.
Don' you forget the last action "option unchecked" ?
And, its better to use Self function so that the calculation can be used in any field.
I tried the self function before I found this online method. Mind you I used it in Cond formatting. Nope, did not work either.
Don't get hung up on XL. I was using it as a metaphor. What I want to achieve is the prevention of ANY formatting of text other than what is applied to the object on the layout.
And yes, I followed the instruction to the letter.
The option is "checked" by default (from some version I forgot), so the document saying "leave" may be confusing.
Wait a minute. I DID have that unchecked but when I checked just now it was checked! Now it works. Thanks.