If you use the following functions to extract the day month and year:

=day(cell ref)
=month(cellref)
=year(cellref)

then use the date function selecting the above cell (E.G
date(daycellref,monthcellref,yearcellref).

That should convert it to a serial number.

Nic

--
nickysquawke
-----------------------------------------------------------------------
nickysquawkes's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=50286