You could type the following directly into the target cells:

=day(A1)
=month(A1)
=year(A1)

Note: A1 contains a date .

This is sensitive to the short date setting in regional settings. Or, use
the following with VBA.

Format("yourdate","dd")
Format("yourdate","mm")
Format("yourdate","yyyy")


"hme" wrote:


Hi

Somebody help me

how can I copy dd, mm and yy from a text "dd/mm/yy" to 3 separate
cells.

thanks and regards
HME


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=320024