Moving down one cell
 

If you don't want to be tied to a macro then you can just highlight the dates
and do a find and replace on the 0 with a 0. When the replace is done it will
implicitly convert the text to a date.
--
HTH...

Jim Thomlinson


"Jordan" wrote:

I have a date listed as APR 2005 or Mar 2005. If I format the column as a
date it doesnt change until I press F2 and hit enter and then it shows as
04/01/2005 or 03/01/2005. Which is what I want.

Can anyone tell me how what code to use to tell it to press F2, hit enter
and then move down one cell until it reaches a blank cell.

Or is there a way to re-calculate all the cells without having to open them?

Thanks in advance for any help you can give me.

Moving down one cell
 

I have something for changing the date back if that helps too...
--
HTH...

Jim Thomlinson


"Jordan" wrote:

Jim, That works perfect and is very simple. Thank you.

"Jim Thomlinson" wrote:

If you don't want to be tied to a macro then you can just highlight the dates
and do a find and replace on the 0 with a 0. When the replace is done it will
implicitly convert the text to a date.
--
HTH...

Jim Thomlinson


"Jordan" wrote:

I have a date listed as APR 2005 or Mar 2005. If I format the column as a
date it doesnt change until I press F2 and hit enter and then it shows as
04/01/2005 or 03/01/2005. Which is what I want.

Can anyone tell me how what code to use to tell it to press F2, hit enter
and then move down one cell until it reaches a blank cell.

Or is there a way to re-calculate all the cells without having to open them?

Thanks in advance for any help you can give me.