If they're really dates, you can use:
=year(a1)
=month(a1)
=day(A1)



Leen wrote:

Hi
I have a large column containing dates is this format

08/12/2008

I want to put the month in it's own column, the day and the year. Basically
split them up into 3 columns.

I have no idea how to go about it.
--
Thank You
Leen

--

Dave Peterson