Thread: Date format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hfazal hfazal is offline
external usenet poster
 
Posts: 22
Default Date format

Hi, I'm writing a Macro, and one of the date columns I want to sort by has
the date in 20060221 format (i.e. 21-Feb-2006), how can I get it a format
that Excel will recognize as a date.

Thanks,
Hussein