Thread: Text to date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jschping jschping is offline
external usenet poster
 
Posts: 8
Default Text to date

Hi,

I am receiving date data in the following format: MM-YY, however, for some
reason there is no first zero. So June 2009 is just 609.

How can I convert it to a date, when I don't know if I'll have 3 digits
there (like the above example) or 4 digits (for example 1109 would be
November 2009).

Thanks!