I am unable to post graphics or screen shots.

07/2008 this would have a strikethrough
08/2008 this would have a strikethrough
09/2008
--------
Test

Then all the items havea strikethrough.

Does this make sense?


"FSt1" wrote:

hi
now i am confused. the technique i posted does not work for numbers or
formulas.
text only. and a date is a number.
post examples of your data. before and after paste.

Regards
FSt1

"Deb" wrote:

Hi FSt1
Thank you for your repsonse, the problem is, the destination cell contains
dates..each time an extension is requested, the user puts a strikethrough the
old date, inserts a new date. This data should be updated on the main page
(introduction). Hopefully this can be done automatically. Does this make
sense?

Thanks so much!

"FSt1" wrote:

hi
high light the text in the formula bar. right clcik the formula bar and
click format cell. remove the strikethrough. press enter.
highlight the word that you want to have the strikethrough in the formula
bar. right click the formula bar. check strikethrough. press enter. done.

the trick is that this in all done in the formula bar not the cell.

Regards
FSt1

"Deb" wrote:

Hi -

I have successfully copied one cell to another within a workbook from one
worksheet to another. The problem is the cell containing the data, some of
the data has a strikethrough....on the destination cell all the text contains
the strikethrough...how can I fix this?