Kenny

if it is in a format that can be recognised by Excel (dd/mm/yyyy,
mm/dd/yyyy, dd-mm-yyyy, etc) then use

=DATEVALUE(A1)

Where A1 has the text date. Then format the resulting serial number as a
date

If you only want to 'kick' the text dates to proper dates, try copying a
blank cell, highlighting the 'text dates' and then EditPaste
special...Values+Add. Then format the serial number as date

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"kenny" wrote in message
...
How to convert text to date format so that I can calculate in excel?
Thanks.