Home |
Search |
Today's Posts |
#1
|
|||
|
|||
strike out feature in excel
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..? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
How do you do a strike out in an Excel cell? | Excel Discussion (Misc queries) | |||
Excel Installing feature | Excel Discussion (Misc queries) | |||
Can I make a custom button in Excel for the Group feature? | Excel Worksheet Functions |