I've never seen this occur.

And I just tried it again.

If you create a new workbook and do this to a couple of cells, then save, close
and reopen, does it happen there?

If no, how about double checking for macros.

Set up that real workbook with a cell with some text crossed out.
Close excel
Open excel in safe mode
File|open your workbook

If it's still broken, then I don't have a guess.

But if it's ok, then maybe you do have a macro you don't realize you have (an
event macro under that worksheet???).

This kind of code:

with worksheets("sheet1").range("a1")
.value = .value
end with

Just a simple .value to .value will cause the whole cell to pick of the
formatting of the first character in that cell.

If you strike out the only middle characters, then close and reopen, is all the
strikeout gone?

If yes, then this is consistent with my guess.




chits wrote:

i am using excel 2003 version.
It has been found sometimes that when i strike out any part of text in one
cell, & save the excel sheet, after re-opening, i find the complete cell(all
text in a cell) striked out.
has anyone faced this problem? i do not have any macro's in my sheet... is
this dependent on any macro settings.. etc... whats the solution for this..?

--

Dave Peterson