Date (dd-mm-yy) > need to split into 3 columns (ie dd mm yy)

[Guest]

Hi there
I have a column of dates (dd-mm-yy) that I want to split into 3 seperate columns ... (ie. column A = dd , column B = mm and column C = yy)
Does anyone know how I can segment the date into 3 different columns
Thanks very much for anyone's help....
Ti

 

[Alan]

Hi there,
I have a column of dates (dd-mm-yy) that I want to split into 3 seperate

columns ... (ie. column A = dd , column B = mm and column C = yy).

 

[Alan]

With the date in A1
In B1 =TEXT(A1,"dd")
In C1 =TEXT(A1,"mm")
In D1 =TEXT(A1,"yy")

Hi there,
I have a column of dates (dd-mm-yy) that I want to split into 3 seperate

columns ... (ie. column A = dd , column B = mm and column C = yy).

 

[Gord Dibben]

Tim

=YEAR(A1) =MONTH(A1) =DAY(A1)

Format to choice.

Gord Dibben XL2002