If it is there as text, use Data/ Text to columns, and use the full stop as
delimiter.
If the 11.12.09 is a real date, use =DAY(A1) =MONTH(A1) and =YEAR(A1) and
copy down.
--
David Biddulph

"RowzeRiot" wrote in message
...
is it possible to split up a cell, if i have a date '11.12.09' and i want
the
day, the month, and the year to be in seperate cells is it possible if so
how? and does it work if i want to do this for a whole collum of dates?