Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David McRitchie
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Opening an Excel file Sheldon Zaklow Excel Discussion (Misc queries) 0 March 3rd 05 10:29 PM
How do you do a strike out in an Excel cell? dgalati Excel Discussion (Misc queries) 1 January 24th 05 09:40 PM
Excel Installing feature Ams Excel Discussion (Misc queries) 1 December 30th 04 09:29 PM
Can I make a custom button in Excel for the Group feature? Lisa Excel Worksheet Functions 1 December 20th 04 09:34 PM


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"