I expect the answer is to not change the cell after having
modified formatting of part of the cell. Watch your use of macros.

Use of F2 put change at formula bar and will not change it,
but use of my TrimALL macro [ join.htm#trimall ] for instance
would reenter the value of the cell and change it. (tested using bold instead of strikeout)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm