Sounds like it is not a date. Try adding a helper column with a formula of

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

and copy down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stittal" wrote in message
...

I know this seems like an easy one, but I am working on a research
project for the Director of the program that I work for and I need to
change the way birthdate is formatted in a particular column. It reads
year first and then month and day.. 20051024 and he wants it to read
10/24/2005. I assumed I could just go to formatting and change it and
it will not let me. There are 6900 some odd records so there is no
possible way to do them manually.. Can anyone help?


--
stittalPosted from - http://www.officehelp.in