On Thu, 8 Sep 2005 10:35:03 -0700, "AG" wrote:

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


You will need to either use VBA to convert it, or enter the data in one column
and convert it with a formula in another.

The formula would be (with your entry in A1):

=--TEXT(A1,"00\/00\/0000") or
=--TEXT(A1,"00\/00\/00")

(depending on which format you decide to use for entry)

and format the cell as a Date


--ron