View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yonah Sudwerts Yonah Sudwerts is offline
external usenet poster
 
Posts: 4
Default How can I convert Text into Date? (See inside)

I have cells that contain Dates such as "Aug 23 2009" but, they were copy
pasted in, and Excell does not see them as dates, is there anything I can
run that can convert them?

I want to be able in the end, that when I open Excell, it can jump to
Today;s date. And alternatively, to have some kind of search option, that
will lead me to any date I want.

But that is part 2, just looking to get the text recognized as Dates to
start.

Thanks in Advance,
Yoni