Good morning, i am currently repeating an operation in several cells as
follows: Copy 19SEP07, Paste Values, F2, Return.

This is achive a date format 19-SEP-07

The reason was i had an original date 19SEP07*, this was brought in from a
lookup formula soit came in with the asteric at the end,( * just mean the
date is constrained) so when it comes in i need to get it in proper date to
show 19-Sep-07.

So initially i used the MID function to loose the * at the end.

Is there a Macro i can write to do all this for me? So step one is to loose
the * then paste back into the cell as 19-SEP-07?

Thanks All...