Hi there..

Yes the cell would contain 5 dates with a resp. ind. name...4 dates have a
strikethrough...since they either missed the deadline or filed for an
extension...there is only one date that does not have a strikethrough...it is
easy enough to do with one cell (manually) but there are multiple
cells....and this data gets pulled and posted on a cover sheet (worksheet).

Is there another way to link to cells to where the destination cells just
pulls data and the format from another cell?

Thanks a million!

"FSt1" wrote:

hi
i know you can't post those but you can type in the data as it apears in the
cell.
do you mean when someone puts a strikethrough on a date, they then enter a
second date in the same cell?
the technique i posted would work for that because with 2 dates in a cell,
excel interpets that as text.

you said in your original post that....
some of the data has a strikethrough.... but after the past......
all the text contains the strikethrough
this is what i am going on.

regards
FSt1


"Deb" wrote:

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?