Thread: Date format
View Single Post
  #1   Report Post  
AG
 
Posts: n/a
Default Date format

I want to have a column to be my date field. I want to be able to enter for
instance 09072005 or 90705 I would like for Excel to be able to convert it to
read 09/07/2005. If I format my cell to Date it reads as ########, If I
leave my cell as General it excepts the number but does not have the slashes.
Thanks for your help.
ANN

--
AG